​Hello,
** Update - I have this working now.  THANK YOU.


I have 2 tables I am trying to join using the NAICS code.  The properties of the Naics Code in each table are listed below.  I have tried, substring to remove the zero in table one.  I have tried using a combination of cast, substring, trim but I am not able to get these tables to join using the NAICS code. 

Can anyone provide some ideas of what I may be doing wrong?

Table 1:
Alpa(15,0)
character length 16
Attribute
This field is prefixed with a 0

Table 2:
Alphs(40,0)
character length 16
Attribute
This field is not prefixed with a 0

Thanks,
Jen

------------------------------
Jenifer Broughton
------------------------------
​
#CognosAnalyticswithWatson

I started from scratch and using a substring to remove the 0 was able to get the tables to join.  Strange I know I had tried that.



------------------------------
Jenifer Broughton
------------------------------