Loop over unknown number of tables

mato32188 — Fri, 30 Sep 2016 13:21:34 GMT

Hi guys,

I am stucked with looping in QlikView.

Need to have loop inside another loop and find the right syntax.

Main problem is that I am using SOAP API, but provider allows only max 100 records per call.

Data structure of calls (cannot be modified)

SOAP calls:

Call1: Call2: Call3:

ID ID, Name ID, Surname

1 1, Mario 1, Wuntd

2 2, John 2, Rough

. . .

100 100, Rob 100, Hershey

---------------------------------------------------------------------------------------

Call4: Call5: Call6:

ID ID, Name ID, Surname

101 101, Gerd 101, Herbs

102 102, Matt 102, Teckly

. . .

200 200, David 200, Diaz

-----------------------------------------------------------------------------------------

Call7: Call8: Call9:

ID ID, Name ID, Surname

201 201, Damon 201, Ypson

202 202, Martin 202, Couf

. . .

234 234, Steve 234, Darms

--------------------------------------------------------------------------------

Call 7, Call 8, Call9 are last tables to be loaded because of no of rows in last load is not 100. Table names are not mandatory.

I need to join tables with same IDs and also keep running load until number of rows in last call is less then 100 (including this table).

Number of tables (vertically) is unknown, we cant say like stop after three iterations.

Thank you for any help.

Best regards,

Martin

Re: Loop over unknown number of tables

marcus_sommer — Fri, 30 Sep 2016 13:37:09 GMT

Maybe something like this is helpful:

let vNumberOfCalls = 100;

for i = 1 to $(vNumberOfCalls)

let vLoadSatement = pick(mod($(i), 3) + 1,

't1: Load ID From YourSource',

't2: Load ID, Name From YourSource',

't3: Load ID, Surname From YourSource');

$(vLoadSatement)

Match:

load * From t1;

left join

load * From t2;

left join

load * From t3;

drop tables t1, t2, t3;

- Marcus

Re: Loop over unknown number of tables

mato32188 — Tue, 04 Oct 2016 06:06:34 GMT

Thank you Marcus. It helped a lot!

topic Re: Loop over unknown number of tables in QlikView

Loop over unknown number of tables

Re: Loop over unknown number of tables

Re: Loop over unknown number of tables