Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (3)
1 Solution

Accepted Solutions
Highlighted
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
Highlighted
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

Highlighted
Anonymous
Not applicable

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