Join with expression

Highlighted
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.

 

 

 


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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch