topic How to create double for loop with Exception in QlikView

How to create double for loop with Exception

Jogi — Sat, 16 Nov 2024 19:23:52 GMT

Hi,

I have a double loop like :

LET vNoOfDB= FieldValueCount('Table1');

LET vNoOfTables = NoOfRows('Table1');

For i = 0 to 10

let = Peek (Field1, $(i), Table1)

For j = 0 to 5

let = Peek (Field1, $(i), Table2)

Some code

And it's working fine, and what I need to loop sometimes the only specific field in Table1 and Table2:

Table1 :

id value

1 2

2 4

Table2:

id value

1 2

10 5

To summarize I need loop only id 1 because it's exists in both tables

Thank you

Re: How to create double for loop with Exception

Anil_Babu_Samineni — Tue, 24 Dec 2019 13:16:59 GMT

Perhaps this?

LET vNoOfDB= FieldValueCount('Table1');
LET vNoOfTables = NoOfRows('Table1');
For i = 0 to 10
let = Peek ('Field1', $(i), 'Table1')
Table1:
Load * Inline [
id, value
1, 2
2, 4
];
For j = 0 to 5
let = Peek ('Field1', $(j), 'Table2')
Concatenate (Table1)
Table2:
Load * Inline [
id, value
1, 2
10, 5
] Where Exists(id,id);
Next j
Next i

Re: How to create double for loop with Exception

Brett_Bleess — Thu, 26 Dec 2019 16:39:52 GMT

Jogi, did Anil's post get you what you needed for your use case? If so, be sure to return to the thread and use the Accept as Solution button on his post to give him credit and let the other Community Members know what worked. If you still require further help, leave an update post.

You may want to try the Design Blog area too if Anil's post did not quite get you all the way there.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

This area of the Community is mostly how-to posts from our internal experts, so you may find it quite useful in helping you flesh out ideas going forward.

One specific post that may be related is the following I think:

https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534

Regards,
Brett

Re: How to create double for loop with Exception

Jogi — Mon, 06 Jan 2020 15:28:22 GMT

Hi all, I manged it to create separate if condition before second loop, thank you all