Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

hejpadig
New Contributor

Load all fields dosen't work with xml-files

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?

Community Browser