Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikEnth
Contributor II
Contributor II

Qliksense - New Column Values Based on Existing Column Values separated by Comma

Hello Experts,

I want to achieve the below for a Data Load Scenario:

Example: I have 5 Columns (ID, Column 1, Column 2, Column 3, Column4 ) i need to create a new Column based on the Four Columns (Column 1, Column 2, Column 3, Column4 ). If there is any data available in that 4 columns, then the new column should have the Data from the 4 columns seperated by comma, if theres no data available in 4 columns then the New column should display as Blank. (See Below for Example Scenario). 

Appreciate our help: Example Table Scenario:

IDColumn1Column2Column3ColumnOutput New Column
1A C A,C
2ABCDA,B,C,D
3 DC D,C
4    **EMPTY**
5AB DA,B,D

 

Thanks.

Labels (2)
0 Replies