Join with expression

Anonymous — Tue, 26 Jun 2018 12:44:14 GMT

I am joining with 2 tables but in one particular column of a table the data needs to be trimmed before checks with the data of similar column in other table.

Ex:

Table1 Data

-----------------

ColumnID

Record-1: C10.443

Record-2: C50.455

To get the description of the above code, i need to join with other table but the value has been trimmed to first 3 characters.

Table2 Data

-----------------------

ColumnID | ColumnName

Record-1 : C10 | Texas

Record-2 : C50 | Indiana

I tried by giving StringHandling.LEFT(ColumnID, 3) in the Table2 expression but its not giving the proper result. Please suggest.

Re: Join with expression

manodwhb — Tue, 26 Jun 2018 12:54:38 GMT

@samisyed80,

can you use row1.field.substring(0,3)

topic Join with expression in Talend Studio

Join with expression

Re: Join with expression