how to combine multiple columns in to single column

+1 vote

i have one table, in table columns contains Master,claimid,billed,paid,servicecode,reasoncodeA1,AmountA1,quanityA1,,...etc we have 9 reasoncoden,Amountn,Quantityn coumns data available. see below columns

Master,Claimid,billed,Paid,servicecode,reasoncodeA1,AmountA1,QuantityA1,ReasoncodeA2,AmountA2,QuantityA2,ReasoncodeA3,AmountA3,QuantityA3,ReasoncodeB1,AmountB1,QuantityB1,ReasoncodeB2,AmountB2,QuantityB2,ReasoncodeB3,AmountB3,QuantityB3,ReasoncodeC1,AmountC1,QuantityC1,ReasoncodeC2,AmountC2,QuantityC2,ReasoncodeC3,AmountC3,QuantityC3.

123,10160623,400,200,Hv:2309,45,100,2,125,120,3,null,-120,4,22,10,1,125,400,20,null,null,null,2,null,1,45,100,2,16,1000,4

234,10160645,500,600,sv:28902,16,100,2,null,120,3,2,-120,4,125,10,1,45,400,20,46,200,null,16,null,1,167,100,2,35,1000,4------50 rows

example_output: Reasoncode by Claimidcount

we need Reasoncodes,Claimid

Null ,   10160623,10160645          

45 ,10160623 

125,10160623,10160645

22,10160623

2 ,10160623,10160645

16,10160645,10160623

167,10160645

 35 ,10160645 

46,10160645           

in power bi how to combine multiple columns in to single column, we do unpivot ..etc.

can you please correct answer.

Jul 17, 2019 in Power BI by Power BI
267 views
Multiple claim-id in 1 column?? Unpivoting is the better option.
it is base on reasons wise claimid.

1 answer to this question.

+1 vote
1. Select Edit Queries

2.Select which column you want to merge or combine

3. Click on   Merge Columns options in Add column Tab
answered Aug 6, 2019 by anonymous

Related Questions In Power BI

+1 vote
1 answer

How to filter on multiple columns in single table

I used dummy data to show how to ...READ MORE

answered Jul 11, 2019 in Power BI by sindhu
4,869 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
28,835 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
1,211 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 33,010 points
5,540 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 22, 2019 in Power BI by anonymous
• 33,010 points
12,346 views
0 votes
0 answers

How to count of category values in a column?

How to count of category values in ...READ MORE

Oct 30, 2019 in Power BI by ch
• 3,450 points
282 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,150 points
412 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,150 points
1,615 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
538 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,370 points
594 views