Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I merge columns/lists of data into one column or list?

I tried this:

CPT:

LOAD  [Unique Identifier],
[CPT_1] as CPT
RESIDENT Claims;

CPT:
LOAD  [Unique Identifier],
[CPT_2] as CPT
RESIDENT Claims;

CPT:
LOAD  [Unique Identifier],
[CPT_3] as CPT
RESIDENT Claims;

All the fields would appear in one list, but the search process did not work. 

11 Replies
Not applicable
Author

When I load the data is there someway I can merge the columns and separate them with a delimiter?

maxgro
MVP
MVP

load

     field1 & '-' & field2 as newfield,

     .....