join into a temp key table

[hagar]

Hey,

I need to create key table between 3 tables, the common between the tables is the date field.

Now one of the 3 tables is excel table which the date is a string.
I managed converting it to be the same as the others using the following:

Date(Date#(COUNT_DATE,'YYYYMMDD'),'DD/MM/YYYY') as OrderDate

but when I try to join all 3 to the temp key table, the 3^rd table (converted one) doesn't join.

Any idea what could it be?
I can share the script in case needed.

Thanks in advance.

[Mark_Little · Accepted solution]

Would be good to see at least example, I would be looking to Concatenate the values in link table or i have in my past use cases. 

Something Like Below

NoConcatenate

LinkTable:

LOAD

'TABLE 1' as Source,

OrderDate as Date

Resident Table1;

Concatenate

LOAD

'TABLE 2' as Source,

Date2 AS Date,

Resident Table2;

Concatenate

LOAD

'TABLE 3' as Source,

Date3 AS Date,

Resident Table3;