Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
divya_anand
Creator III
Creator III

Combine multiple rows into 1 row with different columns

Hi All,

I would like to combine the rows and show the 3 field values (Field 1, Field 2, Field 3) in 1 row for every Code as shown in Screenshot 2.  How do I do this at script level?

I have attached a sample QVW for reference. Thank you.

Capture.PNGCapture2.PNG

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

6 Replies
tresesco
MVP
MVP

Like this?

Capture.JPG

PFA

anushree1
Specialist II
Specialist II

Hi Divya,

To achieve the below Output , you will need to use Generic Load, viz., opposite to Cross Table Load.

Please check the attachment with the desired output hope it helps.

For Easy Usage I just put the data onto an excel, you could as well use Generic keyword on your Inline Load to achieve the same.

divya_anand
Creator III
Creator III
Author

Hi Tresesco,

Works! thank you very much.
divya_anand
Creator III
Creator III
Author

Hi Anushree,

Thank you for the response.
I will check on "Generic".
melghandour89
Partner - Contributor III
Partner - Contributor III

could you post the script for this solution
divya_anand
Creator III
Creator III
Author

Hi,

You can check the script in the QVW attached in the solution post.