Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Incremental Load using Variables

Hi all,

     I have a requirement wherein the incremental load has to be implemented by assigning the script to a variable and the variables are to be used in the place of the script in Edit Script dialog. That is only the declared variables are to be used in the edit script dialog instead of the actual script, so that whenever the tables and its field names are to be changed, we can change it in the declared variables and need not change in the script dialog window.

So can anyone help me with it..?

Thanks in Advance.

1 Reply
peter_turner
Partner - Specialist
Partner - Specialist

Hi,

Are your variables used only for the incremental loading? such as to hold the max row of the last reload?

If so you can play around with the dollar sign expansion such as $(MyVariable) or with single quotes '$(MyVariable)' so QV treats this as a string in the script.