Concat Column

[inam6713]

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

[Lech_Miszkiewicz]

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