1)
If You want to know how to do this in the script to directly export it by "store...into':
In the end of your script do as follow:
for i=0 to NoOfTables()-1
let vTableName$(i)= TableName($(i));
let nOffield=NoOfFields('$(vTableName$(i))');
for j=1 to $(nOffield)
LET Field$(j) = FieldName(j,'$(vTableName$(i))');
final:
load Distinct '$(vTableName$(i))' as TableName, '$(Field$(j))' as Field Resident $(vTableName$(i));
next j
next i
store final into appName.qvd;
Result:
This final table will contain the name of all the tables and the corresponding fields.
You can export this table and have all what you want.
Another dirrect way, is to use system functions that qlik proposes.
Create a simple table with 2 dimension
$Table
$Field
and you'll have what u want; you can then export the table:
2)
To have all he fields of all the app:
I don't think there is a direct way:
but a way to it, is create the above script in all of ur apps; store all of the created final tables in all of the apps in the same folder.
Create a new app:
with only this script:
AllTable
load * from *.qvd;
Now:
store this table that's ll contain all of the tables and fields of all the qlik sense app directly in the script
or create a simple table and export it.
Hope that was clear?
