Load all fields dosen't work with xml-files

Anonymous — Wed, 07 Jun 2017 06:52:25 GMT

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?

topic Load all fields dosen't work with xml-files in QlikView

Load all fields dosen't work with xml-files