Query Builder: How to change the data type of a variable before joining

Valerie_Nedbal

Hello,

Let's assume that you want to make a join in the query builder with a key variable that is in the primary data set as data type character and in secondary data set as data type numeric. This will probably not work. How can we change the data type within the Query Builder to make join working?

Thanks a lot for your help,

Valerie 

martindemel

In the JMP query builder you need to modify the join. You can force matches, even for different data types, as long they match.