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.
