Join with expression

Eight Stars

Join with expression

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.

 

 

 

Tags (2)

Accepted Solutions
Forteen Stars

Re: Join with expression

@samisyed80,

 

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Forteen Stars

Re: Join with expression

@samisyed80,

 

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads