topic Loop through a Table and add to another... in App Development

Loop through a Table and add to another...

ijcornish — Mon, 06 Mar 2017 11:57:11 GMT

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)

Re: Loop through a Table and add to another...

Mon, 06 Mar 2017 14:04:52 GMT

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;