Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Save XML as tables without full load

Hello,

I am new to Qlikview and am trying to load an XML file. The XML loader has correctly (I think) identified all the internal tables and fields, but I'm having trouble loading the data because of current hardware limitations. I'd like to at least save the XML data as distinct CSV or Excel files for inspection. Is this possible?

thank you,

-david

Labels (1)
1 Reply
rbecher
Partner - Master III
Partner - Master III

Hi David,

you could load several partitions of the data of the xml file by looping over a field and using a where clause with a distinct value or a range of values.

Then store the table into a CSV in every loop and drop it afterwards.

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine