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

       

      Load

           date,

           name,

           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.

       

      Thanks,

      Gene