Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jaypadhya
Contributor II
Contributor II

Trimming headers from column and concatenate that to row values

Hi Team,

This is super important for me right now and highly appreciate if someone can help me achieve the following.

I am looking to trim the last part of column values ("_x,""_y,""_z" ) and add it to rows and make the table looks like the following.

Can someone please assist me to get this

Capture.PNG

3 Replies
JustinDallas
Specialist III
Specialist III

Your comma separated value file has no commas...

jaypadhya
Contributor II
Contributor II
Author

Thanks for the heads up,

Check Again its an excel file now

jaypadhya
Contributor II
Contributor II
Author

The answer is to use crosstable individually and then combining the cross tables with RIGHT() function.

Let me know if anyone has question :

jaykashyappadhya@gmail.com