topic Re: Combine multiple rows into 1 row with different columns in App Development

Combine multiple rows into 1 row with different columns

divya_anand — Sat, 16 Nov 2024 21:37:17 GMT

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.

Re: Combine multiple rows into 1 row with different columns

tresB — Thu, 10 Jan 2019 06:47:10 GMT

Like this?

PFA

Re: Combine multiple rows into 1 row with different columns

anushree1 — Thu, 10 Jan 2019 07:25:28 GMT

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.

Re: Combine multiple rows into 1 row with different columns

divya_anand — Thu, 10 Jan 2019 07:46:01 GMT

Hi Tresesco,

Works! thank you very much.

Re: Combine multiple rows into 1 row with different columns

divya_anand — Thu, 10 Jan 2019 07:47:01 GMT

Hi Anushree,

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

Re: Combine multiple rows into 1 row with different columns

melghandour89 — Mon, 21 Jan 2019 08:51:08 GMT

could you post the script for this solution

Re: Combine multiple rows into 1 row with different columns

divya_anand — Mon, 21 Jan 2019 09:22:02 GMT

Hi,

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