Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get all tables from the data modell

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:

get.PNG

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!

Labels (2)
1 Solution

Accepted Solutions
jensmunnichs
Creator III
Creator III

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 

View solution in original post

2 Replies
jensmunnichs
Creator III
Creator III

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
Not applicable
Author

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