0 Replies Latest reply: Jun 7, 2017 2:52 AM by Hej Pa Dig RSS

    Load all fields dosen't work with xml-files

    Hej Pa Dig

      Hi,

      I'm trying to solve a problem where I need to load two different versions of xml files in a folder i.e. the folder contains of x amount of xml files but there are two different types of xml files. This means that the fields that needs to be loaded are slightly different, in xml file type 1 there are y amount of fields, but xml type 2 contains of the fields from xml1 + fieldZ.

       

      I was thinking of using load * and then determine if fieldZ was present or not, and then make an then load either y number of fields or y+1 number of fields with an if statement. However, I get this problem with load *:

           Load all (*) is not allowed in this file type

           Load *,

           FileBaseName() as FileName

       

      Any suggestions?