topic Concat Column in Qlik Automate

Concat Column

inam6713 — Fri, 10 May 2024 06:25:08 GMT

Hello Community,

i have a column in "sectors" and i also have "Tkt_no" column
so same "Tkt_no" I am getting multiple "sectosrs" see blow

current output
"Tkt_no" "sectors"
6697256429 JNBPOL
6697256429 POLJNB
6697256429 BOMDOH
6697256429 DOHJNB

Expected Output
"Tkt_no" "sectors"
6697256429 JNBPOL,POLJNB,BOMDOH,DOHJNB

Re: Concat Column

Lech_Miszkiewicz — Fri, 10 May 2024 06:48:32 GMT

In Script:

Load Tkt_no ,Concat(sectors,',') as Sectors From... Group by Tkt_no;

Or in UI / UI table

Dimension: Tkt_no

Measure: Concat(sectors,',')

You are not describing what is your end game with the sectors column so we are not sure whether you want to use it as dimension or just display as information.

cheers