I have two tables that were coded by different ppl. I need to do join between the two of them.
One of the tables has the date in a number format (201606) and the other in a String format (201606).
I've tried to change both fields to string in the Connection view, however in the join they're still seen as a string and an integer.
I really don't want to make the change at the database level, that will require a lot of changes.