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
Thirteen Stars

Re: Join with expression

@samisyed80,

 

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

Manohar B

All Replies
Thirteen Stars

Re: Join with expression

@samisyed80,

 

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

Manohar B