Creating Join with Two Different Column Types

[Jamil Afza]

I am trying to create a join with one column being an INTEGER and the corresponding column being a VARCHAR. The data in both are actually integers but either the db or Spotfire is recognizing the latter as a VARCHAR.

I have tried the CAST(%1 as VARCHAR(256)) and CAST (%2 as INTEGER) approaches in the freehand join and modfied SQL but both are failing. Any suggestions

[Tyger Guzman 2]

Perform a transformation->change data typeOn one of the columns prior to joining(add columns) the tables in the Data Canvas.