script help

[#1]

hi i have the following  3 records which i hope to flatten out to a single line

current situation

receipt , Item

1, 200

1, 300

1, 250

desired result

receipt, Item

1          200,300,250

is this possible?

best

brad

[maxgro · Accepted solution]

yes, with concat function

a:

load * inline [

receipt , Item

1, 200

1, 300

1, 250

];

b:

NoConcatenate load

receipt, concat(Item, ',') as Item

Resident a

group by receipt;

drop table a;

[#3]

Hi,

Use a char with next expression:

Concat(Item,',')

And thats all. See attached file, second sheet.

Best Regards.