Data type conversion2 followers
I am trying to reconstruct a join that was build in some other system using sql to Datameer. Below is the example used to describe the problem:
from table a
left join table b
on convert(numeric(30), a.col_f ) = convert(numeric(30), a.col_g )
I have tried converting col_f into integer (as col_g is a string of 15 character, converted both into integer to maintain consistency for join) in datameer but I am unable to get the result. Tried couple of different methods but still unable to get it, col_f is a string with 26 characters, which has 11 zeros at the beginning while col_g is a string with length of 15 (no zeros). Tried using substr to remove zeros, any idea how can I approach this problem to get my result for join.