11 Replies Latest reply: Jan 9, 2014 3:21 AM by Daniel Oberbillig RSS

    Can't use Wildcards on field names, what can I do?

    Gene Klayman

      Hello All, I'm loading data from ~100 xml files which have the same field definitions except for the key.  The key is suffixed with random numbers e.g. key12345. 


      Based on the manual I cannot use wildcards in fields names so I cannot say





           key* as key

      from mydir\*.xml.


      I thought about Load * and then using FieldName() function to retrieve the field name, but load * doesn't work with xml files.


      What can I do?


      I do not want to create 100 load statements.