Hi,
I have two date fields in two seperate tables and need these to be one.
Date field 1 - "ZuesDate" in Results table.
Date field 2 - "ActualStart" in Appointments table.
Example-A shows the current table join. Using a mult-box to select a date, either by ZuesDate or ActualStart, shows no results.
Example-B shows the ZuesDate renamed to ActualStart but causes a result. Using a mult-box to select a date, either by ZuesDate or ActualStart, shows no results.
Results Table:
Load
"I_PERSID",
Date(floor(D_DATE)) as ActualStart;
SQL SELECT *
FROM isgus.dbo."RESULTS_BASESUMS_T";
PersInfo Table:
LOAD
"I_PERSID",
"S_PERSNR" AS "Operative Number";
SQL SELECT *
FROM isgus.dbo."PERSINFO_MASTER";
FirstTouchProfiles Table:
LOAD
Value,
PropertyName,
if("PropertyName"='OptiTime_ResourceID', Value,) AS "OptitimeResourceID",
if("PropertyName"='Operative Number', Value,) AS "Operative Number";
SQL SELECT *
FROM "1stTouch_Live".Profile.UserProperties;
Appointment Table:
LOAD
OptitimeResourceID,
Date(floor(ActualStart)) as ActualStart,
SQL SELECT *
FROM MyOptiTime.dbo."tblXWR_Appointments";
Example-A
![Example-A.jpg](/legacyfs/online/25421_Example-A.jpg)
Example-B
![Example-B.jpg](/legacyfs/online/25422_Example-B.jpg)
Hope you can help.
Thanks,
Darren