Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Contributor II

storing system fields


I'm doing some script debugging and want to dump the system fields to file so that I can inspect them.  The STORE statement requires a table name, but I've not found a respective system table that I could reference.  Anyone know of a way to do this?

By way of background, my hand-me-down script has a DROP FIELDS statement with about 40 fields, and it's failing with the complaint that one of the fields is missing.  I quite like being able to insert a "tap point" into my scripts using STORE, so I can check what's going on (I suppose that otherwise, I'll need to thrown in an "exist script" and check it via GUI).


Tags (2)
1 Reply
Not applicable

Re: storing system fields


What i have understood from your question is you want to export the system fields to excel or text files?

You could do it with post reload trigger.

Create a pivot table with all sysyem field. Right click on sheet i.e. GUI and go to "New Sheet Object" --> "System Table". once you do this, write a macro to export this pivot table to desired loaction and map the macro to post reload trigger of Document Property.

Sample Macro to export the data to excel.

Sub ExportData()

'on the place of "CH01" give your pivot table object id

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "C:\test.xls"

End Sub

Hope this helps you.

- Sridhar

Community Browser