topic Re: Loading only a portion of the code in QlikView

Loading only a portion of the code

Wed, 12 Sep 2012 05:05:02 GMT

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

(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

(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

Re: Loading only a portion of the code

whiteline — Wed, 12 Sep 2012 05:19:58 GMT

You can try 'Partial reload' (look at help, its rather simple).

It allows you to leave some tables as is and reload the others.

Re: Loading only a portion of the code

Wed, 12 Sep 2012 07:11:23 GMT

Just Comment the not needed tables and reload or Debug .. Its upto you ...

Re: Loading only a portion of the code

Thu, 13 Sep 2012 00:18:54 GMT

Hi,

I've read it and honestly I can't understand how to use it. The help says something about ADD and REPLACE, do not know how to place it in my code. Can you show me exactly where to place it and what are the effects?

I am very new to QV by the way, and moreso on the coding part.

Thanks

Re: Loading only a portion of the code

Thu, 13 Sep 2012 00:19:54 GMT

Hi,

How exactly do you Comment or Debug? Can elaborate how to do it. I am very new to qlikview by the way.

Thanks

Re: Loading only a portion of the code

whiteline — Thu, 13 Sep 2012 06:22:02 GMT

You should just type it before LOAD statment:

replace

LOAD

...

FROM ...

Then use Partial reload instead of Reload.

Re: Loading only a portion of the code

Jason_Michaelides — Thu, 13 Sep 2012 06:29:56 GMT

DV (Deepak Vadithala) did a couple of great videos on Partial Reloads on his blog. Check them out - www.QlikShare.com

Jason

Re: Loading only a portion of the code

Sun, 16 Sep 2012 23:41:09 GMT

Thank you, your post addressed my question.