topic Re: STORE INTO - as XML? in QlikView

STORE INTO - as XML?

RSvebeck — Mon, 28 Apr 2014 12:03:52 GMT

Need to store a table in XML for use in another external system. This must be done in the QV script, (so no macro solutions please)... 🙂

I have tried doing this for example:

STORE customer INTO D:\Qlikview\TEMP\tb.xml (XmlSimple, Table is [StraightTableBox/customer]);

STORE customer INTO D:\Qlikview\TEMP\tb.txt (txt, delimiter is '/t');

The file tb.txt has content, while the file tb.xml is just blank.

What is the correct syntax? Or is it not possible?

Brg

Robert

hic — Mon, 28 Apr 2014 12:06:32 GMT

Sorry, but it is not possible. QVD and TXT are the only output formats from the Store command.

HIC

RSvebeck — Mon, 28 Apr 2014 12:09:46 GMT

Ok, pitty. But thanks for a quick reply Henric! /Robert

Mon, 28 Apr 2014 17:53:53 GMT

We are working on the same thing. In the next version of BIReport, they may have this option available. I am in talks with BIReport about this now.