Loop through multiple tables with filter

JHoek — Mon, 18 Oct 2021 07:49:13 GMT

I'm trying to create a script to loop through a few tables.

I'm using a database with different administrations. Each administration has his own prefix. But in this example i'd only like to select a few administrations, so for example:

There are 20 administrations:

1. administration1$_Testtable

2. administration2$_Testtable

3. administration3$_Testtable

4-20. Etc >>

If i wanted it all i could have done this:

SELECT
"data"
FROM *_Testtable;

But I would only like to retreive a few selected administrations.

Is it possible to build a list where i can loop through? or should i just select each specific table and then concatenate them?

Thanks in advance!

Re: Loop through multiple tables with filter

rbartley — Mon, 18 Oct 2021 08:03:00 GMT

Hi @JHoek ,

Take a look here: https://community.qlik.com/t5/QlikView-App-Dev/Looping-through-Table-Rows/td-p/395610

topic Re: Loop through multiple tables with filter in App Development

Loop through multiple tables with filter

Re: Loop through multiple tables with filter