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.

View solution in original post


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.

View solution in original post

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog