Join in tMap on value list matching

[Jeebix]

Hello dear community,

I have two csv files and I want through an inner join in a tMap component retrieve matching data. In the first file, the data for the join is a string like 'E100000'. In the other csv file, the data to match is also a string like 'E100000' but it can be like a string concatenation like 'E100000,E100001,E100002'.

I know that to find a string correspondence in a list, it would be like 'field2.split(",")[java.utils.Arrays.asList(

field2.split(",")).indexOf(field1)], but how can I build an inner join between a string and a correspondence in a string list (splitting the other field) ?

Thanks in advance

Jeebix

[manodwhb · Accepted solution]

@Jean-Baptiste Belin​ , You do cartesian join in tMap and in output section of tMap enable filter expression and you can use function like row1.Col.contains(row2.col).

Thanks,

Manohar

[Jeebix]

Hi @Manohar B​ ,

I succeeded with your response. Thanks a lot !

Best regards,

Jeebix

[manodwhb]

@Jean-Baptiste Belin​ ,Glad to help you!