I have to do a left outer join, and I need to write a substring condition on both Key columns of Lookup &Source Tables?

[Ray0801]

How to write a substring condition for the lookup table key column?

For the source table key Column I can write the condition in the Expression key .

I am using Talend Open Studio 7.3.1?

[Anonymous · Accepted solution]

Before tMap, add a new column to the look table, this new column has the substring value of lookup column and it will be used as the join key.

Regards

Shong

[Ray0801]

Thanks @Shicong Hong​ 😅 I didn't think of that,

It worked