Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks!
Any suggestions?