Join error on converted data type

[MTS]

i am using a multi join tool, i changed the data type in the tool to Int 16 to match the other tables field data type, when i run the tool i still get the "strings can only be joined on string type"

does the multi-join tool NOT change the data type... here is a screenshot..

[danrh · Accepted solution]

The Join tools in Alteryx change the datatype AFTER the join has finished, not before.  To resolve, you probably just need to add a Select tool prior to the Join and change the datatype there.