Get all tables from the data modell

[Anonymous]

Hello qlikers 🙂 ,

how can I get the table names of all tables that are shown in the data modell? 

For example, here is my data modell:

Now I want to get all the tables (Data2,MinMaxD...) because I want to save the qvd of all of this.

Is there a option to "loop over the data modell" and get all the table names and save them as qvd?

Thank you in advance!

[jensmunnichs · Accepted solution]

In Qlikview I would do it like this, which I think should work in Qlik Sense as well:

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

STORE $(vTableName) INTO $(vTableName).qvd (qvd);

NEXT vCount

Source 

[Anonymous]

It worked! Thank you very much! 🙂 I wish you a great day.