grouping and transform table in load

bilionut — Fri, 14 Mar 2025 09:29:36 GMT

Hi everyone,

I need to make a new table in load , grouped by the Item column from this

LOAD *
Inline (
'Item', 'Suplier', 'Cod'
'AAA', 'S1', '123'
'AAA', 'S24', '234'
'AAA', 'S3', '554'
'BBB', 'S23', 'abc'
'BBB', 'S77', 'yxz'
'BBB', 'S1', 'uus'
'BBB', 'S234', 'ddd'
'CCC', 'S88', 'acadd'
'CCC', 'S55', 'ddee'
);

to this: