Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?

0 Replies