Discussion board where members can learn more about Qlik Sense App Development and Usage.
Could you please help me how could I get metadata about my tables?
load * inline[
For each ?table? in ?certain_app?
Load Recno() as recnometa
?name of the table? as tablename
Thanks and best regards,
There are a number of table functions that can be used in the script to help.
FOR tableIdx = NoOfTables()-1 to 0 step -1LET vTable = TableName($(tableIdx));TableList:LOAD RecNo() as Number,'[$(vTable)]' as TableNameAutoGenerate 1; NEXT tableIdx;
STORE TableList INTO lib://QVDFiles/TableList.csv (txt);
Thanks for the script you sent, but for me the most important part was to be able to refer to tables using variable. I needed to know how to call a table after "resident" command.
I would like to build a metadata query to retrieve count of records in certain table(s). Furthermore, I would like to get Nb of distinct values, Nb of values in all related fields (one by one).
I have now a script which seems to work fine. I kept searching for scripts shared in Qlik Data Analytics Forums and found one that helped me to build what I need.