tReplaceList not working as expected

[varshakale76]

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

[gjeremy1617088143 · Accepted solution]

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

[varshakale76]

Thank you @guenneguez jeremy​ .

It worked.