Multiple columns distinct data to be merged in one column

[rwaikar]

Hi,

I'm very new in Qlik sense app development and seeking some help to tackle the below mentioned case.

Case:

I've multiple data columns and that whole data I want to merge in just one column with distinct values only.

For example:

Column 1    Column 2    Column 3    Column 4    Column 5

  XXRS              FGFE             OLJL             OUOM          ENWA

  TWNS            ENWA           BEKQ            ZAQE            XXRS

Expected Result:

Column

XXRS             

FGFE            

OLJL            

OUOM         

ENWA

TWNS           

BEKQ           

ZAQE           

[AlzhanNurtaza]

Hey! 

I think you can add one dummy column, for example "Column0" with value "1" then load like "CrossTable"

T1:
CrossTable(Column,Value,1)
Load * inline [
Column0,Column1,Column2,Column3,Column4,Column5,
1,XXRS,FGFE,OLJL,OUOM,ENWA
1, TWNS,ENWA,BEKQ,ZAQE,XXRS
];

T2: 
load 
Distinct
Column,
Value 
Resident T1; 

drop table T1;

[sidhiq91 · Accepted solution]

NoConcatenate
Temp:
Load * Inline [
Column1,Column2,Column3,Column4,Column5

XXRS,FGFE,OLJL,OUOM,ENWA

TWNS,ENWA,BEKQ,ZAQE,XXRS

];

NoConcatenate
Temp1:
Load Column1
Resident Temp;
Concatenate
Load Column2 as Column1
Resident Temp;
Concatenate
Load Column3 as Column1
Resident Temp;
Concatenate
Load Column4 as Column1
Resident Temp;
Concatenate
Load Column5 as Column1
Resident Temp;

NoConcatenate
Temp2:
Load distinct Column1
Resident Temp1;

Drop table Temp,Temp1;

Exit script;

[rwaikar]

As I'm working on some dynamic data where new cell values are keep adding in flow, with few tweaks in above code, I got a resolution my above case. So Thank you for your help. 😊