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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ranjanac
Contributor III
Contributor III

Required Answers - Loop and Incremental load

1. What is the output of the below code along with the explanation?

countries:
Load * inline [
Country
India
USA
UK
Australia
];
For i = 1 to NoOfRows('countries')
For j = 1 to NoOfRows('countries')
T:
Load
$(i) as I,
$(j) as J
AutoGenerate 1;
Next j;
Next i;

2.

if we want to create a table from the scratch in Qliksense and also need to add incremental load in that script. 

how to write the code in case ?

1 Reply
Vicky_Z
Support
Support

You can check this page Loading new and updated records with incremental load  for incremental load