topic Transform multiple rows in one row in QlikView

Transform multiple rows in one row

qlikconsultant — Mon, 19 Sep 2022 16:07:37 GMT

Hi,

I have the following problem:

Data source:

Key	Field A
50\|18052594\|632000\|11,91	3211
50\|18052594\|632000\|11,91	3219
50\|18052594\|632000\|11,91	3329
50\|18052594\|632000\|11,91	4100
50\|18052594\|632000\|11,91	4201
50\|18052594\|632002\|11,91	4201
...

I need to transform this data in the load script to this:

Key	Field A
50\|18052594\|632000\|11,91	3211, 3219, 3329, 4100, 4201
50\|18052594\|632002\|11,91	4201
...

Is there a way to do this? Thanks in advance.

Re: Transform multiple rows in one row

RafaelBarrios — Mon, 19 Sep 2022 18:53:04 GMT

Hi,

you can try Concat() with a group by

tabl1:
Load
concat(field2,',') as filed3,
field1
group by field1;
Load * inline [
field1,field2
50|18052594|632000|11|91,3211
50|18052594|632000|11|91,3219
50|18052594|632000|11|91,3329
50|18052594|632000|11|91,4100
50|18052594|632000|11|91,4201
50|18052594|632002|11|91,4201
];

Keep in mind that in my script for the inline not to create a new column for me, i changed ",91" to "|91"

in your case you will not have to do it.

Hope it helps,

Re: Transform multiple rows in one row

qlikconsultant — Sun, 25 Sep 2022 10:54:08 GMT

Thanks, my idea would have been more complicated.