Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have two tables that I am trying to link using a composite as the dates are not in the same format.
Table 1 Table 2
Consultant Consultant
Hour Date ('dd/mm/yyyy hh:mm:ss') Date ('dd/mm/yyyy')
Hour(Hour Date) as HOUR Hour
Consultant & ' | ' & Hour Date & ' | ' & Hour Consultant & ' | ' & Date& ' | ' & Hour
I did this key but the hour fields don't link. How can I fix it ?
May be this...create composite key from both the table
From source 1:
Consultant & ' | ' & Date(Hour Date, 'DD/MM/YYYY') & ' | ' & Hour as CompositeKey
From source 2':
Consultant & ' | ' & Date & ' | ' & Hour as CompositeKey
Thank you for responding.
Yes, I did what you have provided. But it still does not link my hour fields.
Floor() the timestamp field to remove the time part
Consultant &'|'&Date(Floor(timestamp#(hourdate,'dd/mm/yyyy hh:mm:ss'))) &'|'&Hour(Hourdate) as keyfield