topic Re: How to create combinations of cell values separated by delimiter in Qlik in App Development

How to create combinations of cell values separated by delimiter in Qlik

vish123 — Tue, 30 Nov 2021 16:25:32 GMT

Hi Team,

I have a small requirement as below.

I have two columns with multiple values separated by delimiter. I need to create a combinations as below mentioned.

Please suggest how can i achieve this in Qlik.

Re: How to create combinations of cell values separated by delimiter in Qlik

rubenmarin — Thu, 04 Nov 2021 14:39:55 GMT

Hi, this script can do the work:

OrigData: LOAD * INLINE [ Column1 ;Column2 A,B ;C,D ](delimiter is ';'); // Intermediate table to get the differnt combinations ProcessData: NoConcatenate LOAD Column1, Column2, Subfield(Column1,',') as SplitColumn1, Subfield(Column2,',') as SplitColumn2 Resident OrigData; // Join the differnt rows created and add to the original table to create Column3 Left Join (OrigData) LOAD Column1, Column2, Concat(SplitColumn1 &','& SplitColumn2, '|') as Column3 Resident ProcessData Group By Column1,Column2; DROP Table ProcessData;

Re: How to create combinations of cell values separated by delimiter in Qlik

vish123 — Thu, 04 Nov 2021 14:47:58 GMT

Hi Rubenmarin,

Thanks a ton:) .. its working as expected.