topic Export Structure in QlikView

Export Structure

Tue, 09 Nov 2010 14:57:25 GMT

Hello everyone,

I would like to know how I can export automatically the structure of a document instead of clicking on the 'Export Structure' button in Table Viewer?

I find the '*.Fields.tab' and '*.Mappings.tab' files interesting but I don't want to generate them manually...

Thank you in advance for your help!

Kai

Export Structure

Tue, 09 Nov 2010 15:02:27 GMT

Hello,

you can create (and reuse) a xml-file with: file --> export --> export document layout ==> "myapp.Layout.xml"

HtH, Roland

Export Structure

Tue, 09 Nov 2010 15:19:15 GMT

Hello Roland,

Thank you very much for your message. However, I don't think I have got this 'export document layout' option.

I am thinking of creating a batch file that opens all of the documents and generates 'filename.Fields.tab' but I have no idea how to make it.

Export Structure

Wed, 02 Feb 2011 13:17:13 GMT

Hi, I'm looking for the same thing (and not doing it manually)

I would like the contents from "export document layout" generated automatically, maybe when loading the script. Doing it manually works, but if this could somehow be included in script/macro, even better.

Re: Export Structure

marcelo_7 — Fri, 10 Jan 2020 09:56:29 GMT

You have to make modifications like a loop for all fields and add tablename-information etc. but this is probably what you're looking for.

rem Displays tags for the field
set fld=ActiveDocument.GetFieldDescription("Alpha")
fTags = fld.Tags
dim Tags
Tags=""
for i=lbound(fTags) to ubound(fTags)
Tags=Tags & " " & fTags(i)
next
msgbox(Tags)