Combine multiple rows into 1 row with different columns

[divya_anand]

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.

[tresesco · Accepted solution]

Like this?

PFA

[anushree1]

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]

Hi Tresesco,

Works! thank you very much.

[divya_anand]

Hi Anushree,

Thank you for the response.
I will check on "Generic".

[melghandour89]

could you post the script for this solution

[divya_anand]

Hi,

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