Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

divya_anand
Contributor II

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Combine multiple rows into 1 row with different columns

Like this?

Capture.JPG

PFA

6 Replies
Highlighted
MVP
MVP

Re: Combine multiple rows into 1 row with different columns

Like this?

Capture.JPG

PFA

anushree1
Contributor III

Re: Combine multiple rows into 1 row with different columns

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
Contributor II

Re: Combine multiple rows into 1 row with different columns

Hi Tresesco,

Works! thank you very much.
divya_anand
Contributor II

Re: Combine multiple rows into 1 row with different columns

Hi Anushree,

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

Re: Combine multiple rows into 1 row with different columns

could you post the script for this solution
divya_anand
Contributor II

Re: Combine multiple rows into 1 row with different columns

Hi,

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