Canonical date

[#1]

Hi all,

Anyone help me to create a canonical date for the below data in "Qlik Sense".

In below data, I need canonical date for, date_created, date_completed and date_signed.

LIB CONNECT TO 'MyDB';

LOAD `invitation_id`,

    `client_id`,

    `batch_meta_data_id`,

     activated,

     `date_created`,

    `date_activated`,

     `campaign_name_id`;

SQL SELECT `invitation_id`,

    `client_id`,

    `batch_meta_data_id`,

    activated,

    `date_activated`,

    `date_created`,

    `campaign_name_id`

FROM rcdbrpt.invitation;

LIB CONNECT TO 'MyDB';

LOAD `course_completion_id`,

    `invitation_id`,

    `final_test_status`,

    `course_completed`,

    `date_completed`;

SQL SELECT `course_completion_id`,

    `invitation_id`,

    `final_test_status`,

    `course_completed`,

    `date_completed`

FROM rcdbrpt.coursecompletion;

LIB CONNECT TO 'MyDB';

LOAD `invitation_id`,

    `user_signed`,

    landing_page_accessed,

    `date_signed`;

SQL SELECT `invitation_id`,

    `user_signed`,

    `date_signed`,

    landing_page_accessed

FROM rcdbrpt.signupactivitylog;

Advance Thanks,

pramod

[jonathandienst]

Have you read this: Canonical Date

[#3]

Yes, i tried many things. but it's not getting. so i posted here.

please help me write code for that.

Thanks,

Pramod

[#4]

Hi Pramod

all the dates are in separate tables. We can create a duplicate field in each table and rename with same field name.

Ex. date_created as Date

    date_completed as Date

date_signed. as Date.

So if we will make selection to Date Field, data for each table will get selected.

I am not very sure if this is you are looking for.