topic Re: How to load XML files in a loop with known tables but different/unknown fields? in QlikView

How to load XML files in a loop with known tables but different/unknown fields?

Thu, 29 Jan 2015 08:56:02 GMT

Hi,

I hope someone can help me.

I have to load thousands of XML files with known tables but different fields. I’m using “for each” to load the XML files one after another and store the tables into qvd files. Since it’s not allowed to load the tables with wildcards “*”, I am currently loading the tables with the matching fields (in the example below field A). But now I need all available fields.

How to load XML files in a loop with known tables but different/unknown fields?

I know how to load all files and I also can load the different tables. Is it possible to get all fields for a given table?

Kind regards

Nina

Example:
First XML:

Load      A,
                B,
                C

From Table1.xml ((XmlSimple, Table is [Table])

Second XML:

Load A,
C

From Table2.xml ((XmlSimple, Table is [Table])

Third XML:

Load A,
B

From Table3.xml ((XmlSimple, Table is [Table])

Re: How to load XML files in a loop with known tables but different/unknown fields?

Michiel_QV_Fan — Wed, 25 Feb 2015 12:32:17 GMT

Only if you load all fields hard coded. XML cannot, as you experienced allready, load wildcards.

XML and QlikView aren't best friends so to speak.

Re: How to load XML files in a loop with known tables but different/unknown fields?

Anonymous — Wed, 25 Feb 2015 19:35:33 GMT

You must create a External Process and will be called with "Execute" command.

The XML files are not the best data input for QV.

Re: How to load XML files in a loop with known tables but different/unknown fields?

Anonymous — Thu, 02 Feb 2017 12:47:03 GMT

Yes. Use this:

LOAD * From Table1.xml ((XmlSimple, Table is [Table])