cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
varunvyas New Member
New Member

Merge 17 columns of data to populate single column with all list of values

I have table as source for my report where data values are coming in from 17 different columns

e.g.

 

employee #      Level_1_User      Level_2_User      Level_3_User     Level_4_User

N000789            N000123             N000234            N000345            N000456

N000147            N000123             N000234            N000876             

N000852            N000123             N000963            N000632            N000888

 

 

For above example I wanted to create a single column that sources values from Level_1_User, Level_2_User,Level_3_User,Level_4_User and generates the distinct list of values as result column.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Merge 17 columns of data to populate single column with all list of values

@varunvyas

 

Hi, In Query Editor you can Select Employee# column and unpivot other columns. After that select the column and Remove Duplicates (In Transform Menu)

 

Regards

Victor

Lima - Peru




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Highlighted
Super User
Super User

Re: Merge 17 columns of data to populate single column with all list of values

@varunvyas

 

Hi, In Query Editor you can Select Employee# column and unpivot other columns. After that select the column and Remove Duplicates (In Transform Menu)

 

Regards

Victor

Lima - Peru




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!