Discussion Board for collaboration on QlikView Scripting.
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')
FileName() as file_name,
FileBaseName() as file_base_name,
FilePath() as file_path,
FileTime() as file_time
(XmlSimple, Table is [entries/entry]);
order by file_time DESC
Drop Table FileInfo
Let source = fieldname(3, 'LatestFiles')
Let source_i = fieldvalue('$(source)',1)
For i = 1 to NoofRows('LatestFiles')
'$(source_i)' as $(source)
(XmlSimple, Table is [entries/entry]) ;
Let source_i = fieldvalue('$(source)',$(i)+1)
Go to Solution.
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.
Thanks Gysbert. You are genious.