3 Replies Latest reply: Jun 10, 2015 4:53 AM by Ashish Tuti RSS

    Canonical date

    Kumar Pramod

      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