Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

(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

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Loading only a portion of the code

You should just type it before LOAD statment:

replace

LOAD

...

FROM ...

Then use Partial reload instead of Reload.

7 Replies
whiteline
Honored Contributor II

Re: Loading only a portion of the code

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

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

Not applicable

Re: Loading only a portion of the code

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

Not applicable

Re: Loading only a portion of the code

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

Not applicable

Re: Loading only a portion of the code

Hi,

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

Thanks

whiteline
Honored Contributor II

Re: Loading only a portion of the code

You should just type it before LOAD statment:

replace

LOAD

...

FROM ...

Then use Partial reload instead of Reload.

jason_michaelid
Honored Contributor II

Re: Loading only a portion of the code

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

Jason

Not applicable

Re: Loading only a portion of the code

Thank you, your post addressed my question.

Community Browser