Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Switch Between Full Load And Incremental Load

All,

I have small Qlikview Project. In my Script Editor window i made two tab one for Full Data Load And other for Incremental Load.

How I Switch between Full load and incremental load tabs in reloading time...?

Or Is there any other way to perform Full data load or Incremental load based on end user action..?

Regards,

Faisal

12 Replies
avinashelite

Hi Faisal,

first identify Based on which condition you want the incremental and full load.

Then use conditions functions like If and verify the condition, if it satisfy then direct it to  increment or full load

Not applicable
Author

Hi Avinash,

Thanks for the reply.

There is two options

1.     Initial load will be full load and after that each reloading time 'incremental load' have to perform

2.     End user can take decision whether he want full data load or Incremental load in dynamic way

Regards,

Faisal M A

avinashelite

I think this is not possible!! because how will you get the user input every time??? and it will be a manual work to get the user selection and reading that in the script is very tedious.

so you have to decide whether you want a full reload or only incremental load and design the same rest of the schedule reloading task will be taken care by QMC.

Not applicable
Author

Then can you please explain, how will perform the first option.

Also Is there any way to perform second option using button or some thing

Like below

Regards,

Faisal

avinashelite

Ok see, in the button background you need to set a variable in the front end.

say the variable name vReload and set value using the action (see in the button properties) to Full load or Incremet

then in the script try like this:

let vReload_parameter=$(vReload);

if vReload_parameter='Full load'

then

your full reload script

....

else

your incremental reload script

Not applicable
Author

Ok I Understand Thanks.

But one more question,

How we know in Reloading time, if it is first reload

Regards,

Faisal

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this link, hope it help syou.

Getting Input while reloading in Qlikview

Temp:

LOAD

Input('Enter Load Type', 'Input box') AS InputValue

AutoGenerate 1;

LET vLoadType = Peek('InputValue');

DROP TABLE Temp;

IF vLoadType = 'Full' THEN

     // Your Full Load script goes here

ELSE

     // Your Incremental Load script goes here

ENDIF;

Hope this helps you.

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

If user enter Full, then Full load is performed otherwise incremental load is performed.

Regards,

Jagan.

Not applicable
Author

Hi Jagan,

When I open the link following error is coming

Also can you please explain more about Full Load and Incremental load.

What I want is First load will Full Load after all load would be Incremental load.

Which condition will give without input box or button...?

Regards,

Faisal M A