Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should just type it before LOAD statment:
replace
LOAD
...
FROM ...
Then use Partial reload instead of Reload.
You can try 'Partial reload' (look at help, its rather simple).
It allows you to leave some tables as is and reload the others.
Just Comment the not needed tables and reload or Debug .. Its upto you ...
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
Hi,
How exactly do you Comment or Debug? Can elaborate how to do it. I am very new to qlikview by the way.
Thanks
You should just type it before LOAD statment:
replace
LOAD
...
FROM ...
Then use Partial reload instead of Reload.
DV (Deepak Vadithala) did a couple of great videos on Partial Reloads on his blog. Check them out - www.QlikShare.com
Jason
Thank you, your post addressed my question.