topic Re: Rows to Column in App Development

Rows to Column

masalas232 — Tue, 25 Apr 2023 18:15:18 GMT

I have data in the following format:

Need to transform into the following:

rwunderlich — Tue, 25 Apr 2023 22:45:11 GMT

Use Concat() and Group By:

LOAD
TransID,
Concat(ProductID, ', ') as Products
Inline [
TransID ProductID
1 a
1 b
1 c
2 b
2 d
2 e
2 f
] (delimiter is '\t')
Group by TransID
;

Hania — Wed, 26 Apr 2023 10:13:23 GMT

you can use Generic load .

hope this is useful!

Chanty4u — Thu, 27 Apr 2023 17:55:22 GMT

// load the original table

LOAD

TransID,

ProductID

FROM data.csv (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

// group by TransID and concatenate ProductIDs

LOAD

TransID,

concat(ProductID, ', ') AS Products

RESIDENT

OriginalTable

GROUP BY

TransID;

// drop the original table

DROP TABLE OriginalTable;