topic Re: Exporting All fields from all tables to excel spreadsheet or text file in QlikView

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

Thu, 22 Mar 2012 19:45:21 GMT

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

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

lorenwood — Wed, 11 Jul 2012 21:34:42 GMT

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

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

nagaiank — Wed, 11 Jul 2012 22:07:09 GMT

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

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

Tue, 11 Aug 2015 15:34:48 GMT

Document Properties > Tables > Export Structure

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

Gabriel — Tue, 11 Aug 2015 15:58:08 GMT

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.

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

olivierfelix — Tue, 23 Jan 2018 12:11:01 GMT

Your old anwer help me now.

Good soluce.