topic Re: How to use recursion in QAA? in Qlik Automate

How to use recursion in QAA?

p0cket0m — Fri, 15 Nov 2024 20:56:13 GMT

We use the List files block to access files on our SharepointOnline site

How can we achieve recursion to navigate into subfolders without knowing the depth of folder hierarchy?

At the end, we want a list of all leafs (files), no matter how many subfolders exist and how deep hierarchy goes.

We want to avoid using a nested blocks scenario like this

Any ideas would be highly appreciated 👍

Re: How to use recursion in QAA?

p0cket0m — Fri, 08 Nov 2024 09:16:38 GMT

I tried this

But the process doesn't fork and it iterates only over the first branch of the tree.

Re: How to use recursion in QAA?

gopipnr — Fri, 08 Nov 2024 09:50:09 GMT

Instead of using a single loop, break each process into specific labeled steps, allowing you to navigate between them using conditions that iterate through each step.

Re: How to use recursion in QAA?

p0cket0m — Fri, 08 Nov 2024 18:02:01 GMT

Unfortunately this doesn't seem to work with the List files on Sharepoint block. It stops after the first branch only reading folder 1 and file 2,3 but it doesn't proceed to folder 2. The program doesn't continue after the Go To Label block.

Re: How to use recursion in QAA?

p0cket0m — Fri, 08 Nov 2024 18:38:39 GMT

Figured out why, you cannot add blocks after a Go To Label block. They don't connect. Only the blue path is possible. After breaking the loop, it cannot reach the Output block below Go To Label 3 block (red path).