Loop through a Table and add to another...

[ijcornish]

Hi all,

I am working on Load script for Qlik Sense app, and need to be able to loop through the rows in a table, and add records to another table based on a series of logical analysis of the data.

Table Example:

SourceData

RecNo	A	B	C
1	Open	1/1/2017	28/2/2017
2	Closed	30/1/2017	28/2/2017
3	Pending	2/3/2017

I want to loop through all the records in this table (there are currently ~10k records), and populate another table (which will link via RecNo to this) with the results of that analysis (Effectively an Audit Analysis)

[#2 · Accepted solution]

it's called resident load

so eg

SourceData:

load * inline [

RecNo,A,B,C

1,Open,1/1/2017,28/2/2017

2,Closed,30/1/2017,28/2/2017

3,Pending,2/3/2017,

];

AuditTable:

load

     RecNo,

     'whatever data you want' as Whatever

resident SourceData;