Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
inam6713
Contributor
Contributor

Concat Column

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

Labels (3)
1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.