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

[#1]

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])

[Michiel_QV_Fan]

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.

[Anonymous]

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

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

[Anonymous]

Yes. Use this:

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