topic Re: Sort and Concatenate in QlikView

Sort and Concatenate

siddharth_kulka — Sat, 16 Nov 2024 19:10:02 GMT

Hi,

Hoping for steer on below requirement:

Check all values in the 6 digit SSN field. If any 5 of the 6 digits match then concatenate using any delimiter else do not concatenate.

In below example,

5 SSN digits match for ID's 1,2. Also all SSN 6 digits match for IDs 2,4 (order not relevant).

Hence, rows need to be concatenated for both fields.

Data
SSN	ID
012345	1
321654	2
144543	3
123456	4

Expected Output

SSN	ID
012345\|321654\|123456	1\|2\|4
144543	3

Any help would be welcome. Thanks in adv

Re: Sort and Concatenate

sunny_talwar — Fri, 07 Feb 2020 14:11:12 GMT

144543 have all six digits matching with 012345

Re: Sort and Concatenate

Saravanan_Desingh — Thu, 30 Apr 2020 23:12:10 GMT

Can you check this?

tab1: LOAD SSN, ID, Concat(Tuple,'',Col) As Pat Group By SSN, ID ; LOAD *, If(Index(SSN,IterNo()-1)>0,IterNo()-1,'X') As Tuple, IterNo()-1 As Col While IterNo()<=10 ; LOAD SSN-0 As SSN, ID INLINE [ SSN, ID 012345, 1 321654, 2 144543, 3 123456, 4 ];