1 Reply Latest reply on Dec 20, 2016 12:48 PM by Matthew Risley

    Create Data Source - Join two fields of different Data Types

    Eric Saragosti

      Hi There,

      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.

      Any ideas?