Two dates into one

darren_dixon — Wed, 21 Nov 2012 13:07:24 GMT

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-B

Hope you can help.

Thanks,

Darren

topic Two dates into one in QlikView

Two dates into one