Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting All fields from all tables to excel spreadsheet or text file

Hi All,

I have a simple problem, where I'd like to export all the field names of all the tables that I have in my data model to an excel spreadsheet or a text file. It should also include all the derived fields as well. Could anyone please tell me if this is possible in Qlikview?

Thank you. I'd really apprecicate your reply.

-Yaman

5 Replies
lorenwood
Contributor III
Contributor III

Hi have you tried export structure in source table view? Convert File to text and it should help you out

nagaiank
Specialist III
Specialist III

You can create a System Table object which lists all the tables and their fields and export it to Excel.

Not applicable
Author

Document Properties > Tables > Export Structure

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Just have $Field as list box this will give you all the fields in your data model and right click select Send to Excel.

olivierfelix
Contributor II
Contributor II

Your old anwer help me now.

Good soluce.