3 Replies Latest reply: Feb 2, 2017 7:47 AM by Станислав Строгий RSS

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

    Nina Wischer

       

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