topic script help in QlikView

script help

Thu, 20 Nov 2014 21:51:35 GMT

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

Re: script help

maxgro — Thu, 20 Nov 2014 22:00:59 GMT

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;

Re: script help

Thu, 20 Nov 2014 22:02:32 GMT

Hi,

Use a char with next expression:

Concat(Item,',')

And thats all. See attached file, second sheet.

Best Regards.