topic Join in tMap on value list matching in Talend Studio

Join in tMap on value list matching

Jeebix — Wed, 16 Dec 2020 08:43:09 GMT

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

Re: Join in tMap on value list matching

manodwhb — Wed, 16 Dec 2020 08:58:57 GMT

@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

Re: Join in tMap on value list matching

Jeebix — Wed, 16 Dec 2020 10:04:02 GMT

Hi @Manohar B ,

I succeeded with your response. Thanks a lot !

Best regards,

Jeebix

Re: Join in tMap on value list matching

manodwhb — Wed, 16 Dec 2020 10:33:00 GMT

@Jean-Baptiste Belin ,Glad to help you!