topic Re: tReplaceList not working as expected in Talend Studio

tReplaceList not working as expected

varshakale76 — Mon, 10 May 2021 14:48:38 GMT

Hi team,

one column of excel file need to be replaced with other lookup data.

I tried by using tReplaceList component but its not giving me the expected result. some values are not replaced and also getting trimmed. some of the values are getting replaced correctly.

I could find from community that tReplaceList has bug.

Please suggest how I can replace the column values with lookup values.

Job design

Re: tReplaceList not working as expected

gjeremy1617088143 — Mon, 10 May 2021 14:57:00 GMT

Hi do it in a tMap , with a main row and a lookup row, make an inner join with the key values in common, then just select the value of the lookup in the tMap output column.

Send me Love and Kudos

Re: tReplaceList not working as expected

varshakale76 — Mon, 10 May 2021 15:35:56 GMT

Thank you @guenneguez jeremy .

It worked.