Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
It worked! Thank you very much! 🙂 I wish you a great day.