topic Join on a pattern in QlikView

Join on a pattern

sujit_nath — Fri, 19 Oct 2018 05:28:51 GMT

I have a table A such as :

and table B such as:

Now I want to take the feild ID as key and add the concatenated value to the table(left join).

-Also table A may have shared values as mentioned and table B has single values.

The resultant table will be like:

This would match the ID's and concatenate the value column and add it to table A.

Hope the question is clear.

Thanks and Regards,

Sujit!!

andrey_krylov — Fri, 19 Oct 2018 06:09:31 GMT

Maybe this

[Table1]: LOAD ID, PurgeChar(SubField(ID, ']['), '[]') as ID_2

Inline "

[22][12][11]

[45]

[77][23]

[56][78]

[10][11]

[2][19]

[22]

Left Join LOAD ID as ID_2, value Inline "

ID, value

22, Y

12, N

45, N

77, N

56, N

78, N

10, Y

2, Y

19, N

23, N

33, Y

11, Y

;

[Table2]: LOAD ID, Concat(value) as value Resident [Table1] Where Len(ID) > 0 Group By ID ;

DROP Table [Table1];