xml file

ashwanin — Thu, 21 May 2015 18:57:15 GMT

Hi Qlik Users,

I required the latest XML file from a folder (abc) and want to put the data in a QVD.

But i am facing problem with the part Highlighted in bold underline below (in script)

Error which i am getting : Load all (*) is not allowed in this file type

Please tell me what i am doing wrong and how to rectify that.

Thanks in advance

set folder = "abc"

;

for each file in filelist('$(folder)\*.xml')

FileInfo:

Load

Distinct

FileName() as file_name,

FileBaseName() as file_base_name,

FilePath() as file_path,

FileTime() as file_time

from

$(file)

(XmlSimple, Table is [entries/entry]);

;

next file

Qualify *

;

LatestFiles:

First(1)

Load *

resident FileInfo

order by file_time DESC

;

Drop Table FileInfo

;

UNQUALIFY *

;

Let source = fieldname(3, 'LatestFiles')

;

Let source_i = fieldvalue('$(source)',1)

;

For i = 1 to NoofRows('LatestFiles')

[File$(i)]:

Load *,

'$(source_i)' as $(source)

from

$(source_i)

(XmlSimple, Table is [entries/entry]) ;

Let source_i = fieldvalue('$(source)',$(i)+1)

;

next i

exit script

;

Re: xml file

Gysbert_Wassenaar — Fri, 22 May 2015 09:34:37 GMT

That's right. When you load data from an xml file you have to specify all the field names explicitly. The * is not allowed for loads from xml files.

Re: xml file

ashwanin — Fri, 22 May 2015 10:10:54 GMT

Thanks Gysbert. You are genious.

topic Re: xml file in QlikView

xml file

Re: xml file

Re: xml file