2 Replies Latest reply: Aug 3, 2012 3:34 AM by patsys50 RSS

    Mapping fields from different tables

      Hi all,

       

      I am very very new to qlikview and I am using the personal edition.

       

      I have 3 tables which came from 3 different worksheets of an excel file.

       

      The code I have are as per below:

       

      LOAD PSC, 
           FUNCTION_DOMAIN, 
           TASK_CONTROL_ID, 
           PROCESS_REFNUM, 
           MI_INVENTORY_ID, 
           REPORT_NAME, 
           TASK_ID, 
           TASK_NAME, 
           TASK_PROCESSOR, 
           TASK_START_DATE, 
           TASK_END_DATE, 
           TASK_DURATION, 
           TASK_RAG, 
           TASK_STATUS, 
           TASK_ACTION_STAT, 
           PROC_ID, 
           ACTUAL_TASK_START_DATE, 
           CYCLE_TIME, 
           Calendar_Date
      FROM
      [C:\Documents and Settings\All Users\Documents\PATSYS50\DILO\Control_Report_V5.7 2012 07.xlsm]
      (ooxml, embedded labels, table is SWF_DATA_CONTROL_REPORT);
      LOAD TRAN_ADHC_ID, 
           [Entity ID], 
           [Process ID], 
           [Process Name], 
           [Adhoc Category ID], 
           [Category Name], 
           PSC_FUNCTION1, 
           Processor, 
           [Start Date/Time], 
           [End Date/Time], 
           [Elapsed Time], 
           [Manual Start Date/Time], 
           [Manual End Date/Time], 
           [Calendar Date], 
           NEW_CALENDAR_DATE, 
           ORIG_CYCLE_TIME, 
           ADJUSTED_CYCLE_TIME, 
           NEW_START_DATE_TIME, 
           New_END_DATE_TIME
      FROM
      [C:\Documents and Settings\All Users\Documents\PATSYS50\DILO\Control_Report_V5.7 2012 07.xlsm]
      (ooxml, embedded labels, table is TT_DATA_CONTROL_REPORT);
      LOAD [email ID], 
           [First Name], 
           [Last Name], 
           Team, 
           Location, 
           [Manager/TL], 
           [Supervisor/POC], 
           [Workstream Head], 
           [Coverage Head], 
           Att_01, 
           Att_02, 
           Att_03, 
           Start_User_Date, 
           End_User_Date, 
           Location_ID
      FROM
      [C:\Documents and Settings\All Users\Documents\PATSYS50\DILO\Control_Report_V5.7 2012 07.xlsm]
      (ooxml, embedded labels, table is USER_LIST);
      

       

       

      The fields TASK_PROCESSOR (from the field table) and Processor (from the 2nd table) are referring to the email addresses of the staff.

       

      The 3rd table has the master list of email addresses [email ID] and the corresponding team Team .

       

      Basically all I want to do is to "map " the fields TASK_PROCESSOR, Processor and [email ID] so that if I select the TEAM from a listbox the rest of the data from the other tables will follow.

       

      Thanks in advance.

        • Re: Mapping fields from different tables
          Niky Rathod
          LOAD  TASK_PROCESSOR as Staff_EmailID, 
          FROM
          [C:\Documents and Settings\All Users\Documents\PATSYS50\DILO\Control_Report_V5.7 2012 07.xlsm]
          (ooxml, embedded labels, table is SWF_DATA_CONTROL_REPORT);
          
          LOAD Processor as Staff_EmailID, 
          FROM
          [C:\Documents and Settings\All Users\Documents\PATSYS50\DILO\Control_Report_V5.7 2012 07.xlsm]
          (ooxml, embedded labels, table is TT_DATA_CONTROL_REPORT);
          
          LOAD [email ID] as Staff_EmailID, 
          FROM
          [C:\Documents and Settings\All Users\Documents\PATSYS50\DILO\Control_Report_V5.7 2012 07.xlsm]
          (ooxml, embedded labels, table is USER_LIST);
          
          

           

          Try this.. Creating Alias would make a physical join from the three different tables.

           

          You can check the join after your load with Ctrl+T

           

          Hope it helps...