Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export table structure of Qlikview Document using macro.

Hi All,

As we all know we have option to export table structure and related information about qlikview table present in data model. We can do this manually by going to Settings->Document Properties->Tables->Export Structure. But I want to automate it and export it using macro.

Can we do this using macro ? Please Help.

Thanks in Advance. Regards, Vivek                              

2 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Vivek,

Did you find the way to do this?  I am looking to do it myself and I've not found any other documentation on the topic.

Thanks in advance,

Steve

marcelo_7
Creator
Creator

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)

 

From the API-application the class IFieldDescription also has the Members "Name" and "SrcTables" which might help creating the total.