7 Replies Latest reply: Sep 16, 2012 7:41 PM by patsys50 RSS

    Loading only a portion of the code

      Hi all,

       

      I have the below code

       

      LOAD TRAN_ADHC_ID,
           [Entity ID],
           [Process ID],
           [Process Name],
           [Adhoc Category ID],
           [Category Name],
           PSC_FUNCTION1,
           Processor as PROCESSOR,
           [Start Date/Time],
           [End Date/Time],
           [Elapsed Time],
           [Manual Start Date/Time],
           [Manual End Date/Time],
           [Calendar Date],
           NEW_CALENDAR_DATE as Calendar_Date,
           ORIG_CYCLE_TIME,
           ADJUSTED_CYCLE_TIME,
           NEW_START_DATE_TIME,
           New_END_DATE_TIME
      FROM
      [C:\Documents and Settings\All Users\Documents\PATSYS\DILO\FA_SWF_TTT_Usage_Control_Report_V5.7 2012 07.xlsx]
      (ooxml, embedded labels, table is TT_DATA_CONTROL_REPORT);

       

       

       

      LOAD [email ID] as PROCESSOR,
           [First Name],
           [Last Name],
           Workstream,
           Location,
           [Manager/TL],
           [Supervisor/POC],
           [Workstream Head],
           Att_01,
           Att_02,
           Att_03,
           Start_User_Date,
           End_User_Date,
           Location_ID
      FROM
      [C:\Documents and Settings\All Users\Documents\PATSYS\DILO\FA_SWF_TTT_Usage_Control_Report_V5.7 2012 07.xlsx]
      (ooxml, embedded labels, table is USER_LIST);

       

       

      There was a change in the table USER_LIST and so I would like to update qlikview.

       

      Normally I would just click RELOAD. Problem is that this takes sometime because this reloads everything.

       

      Is there a way so that only the 2nd portion of the code above is reloaded?

       

      Thanks