Discussion Board for collaboration on QlikView Scripting.
I will load first the qvd files and then the xml from the last change xml files
i am loading today the script form qvd files we have then a new xml file from my cash server
everyday makes the cash server a xml file and store this in the folder
we can help me with the script.
Go to Solution.
See attached qvw.
Try something like this:
for each File in filelist ('FX*.xml')
Load '$(File)' as Name,
date#(keepchar('$(File)','0123456789'),'YYYYMMDD') as FileDate
1 as dummy
Order By FileDate DESC;
drop table Folder;
LET varLatestFile = PEEK('Name' , 0, 'LatestFile');
drop table LatestFile;
load * from Addondemo.qvd (qvd);
concatenate (addon) LOAD ProdNr
FROM $(varLatestFile) (XmlSimple, Table is [Tickets/Ticket/Order/Line/Addon]);
Store Addon into Addondemo.qvd;
Can you show me in the qlikview script, i don't understand this.
and send it as attachment.
The loading from pad for each File in filelist ('FX*.xml') = this the padname what i have used in the script then teh wildcard for all xml files.