Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ijcornish
Not applicable

Loop through a Table and add to another...

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

    

RecNoABC
1Open1/1/201728/2/2017
2Closed30/1/201728/2/2017
3Pending2/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)

1 Solution

Accepted Solutions
Not applicable

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

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;

1 Reply
Not applicable

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

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;