Tool to extract all the fields and tables used in back-end

[MindaugasBacius]

Greatings,

I need somehow to do the QlikView audit through the whole QV ETL. Basically, I need to get all the tables and fields that are being used in the back-end.

I have checked the Script Log Analyzer and the Document Analyzer created by Rob. But it seems that those apps are used for other purposes.

Does anyone have ideas regarding my issue?

Thank you!

[tresesco]

If you are trying to get information from the script about the same app, you could probably use table functions, like : NoOfTables(), NoOfFields(). Something like:

//Iterate through the loaded tables
For t = 0 to NoOfTables() - 1

//Iterate through the fields of table
 For f = 1 to NoOfFields(TableName($(t)))
  Tables:
  Load 
   TableName($(t)) as Table,
   TableNumber(TableName($(t))) as TableNo,
   NoOfRows(TableName($(t))) as TableRows,
   FieldName($(f),TableName($(t))) as Field, 
   FieldNumber(FieldName($(f),TableName($(t))),TableName($(t))) as FieldNo
   Autogenerate 1;
 Next f
Next t;

Qlik table functions 

[MindaugasBacius]

Thank you for your reply  Tresesco.

That might be an option.

But I am renaming and dropping the fields. 

NoOfTables(), NoOfFields() shows only the end result but nothing what's in between 🙂 

[tresesco]

In that case, I would try to see if I can export the script and then read it back to scan and prepare report. Also, I guess if we could go through the Rob's doc analyzer, we would certainly get some inspiration.

[rwunderlich · Accepted solution]

What you want is the NodeGraph Data Atlas. https://www.nodegraph.se/

-Rob

[MindaugasBacius]

Great, thank you Rob!