Left Join in Alteryx

[Satyaki04]

I have records in a table 'X' and I want to reconcile it with table 'Y'. The cases in table 'Y' where the corresponding details are not available can be updated as 'Not specified'. Please guide me on the process.

[AkimasaKajitani · Accepted solution]

Please check where if the field type of key field at both tables are the same.

If the field type of the key is String at one table and another key is Int64, you can not Join the table because it doesn't appear as a candidate key to join