Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I will load first the qvd files and then the xml from the last change xml files
example
i am loading today the script form qvd files we have then a new xml file from my cash server
see attachment
everyday makes the cash server a xml file and store this in the folder
we can help me with the script.
Try something like this:
Directory;
for each File in filelist ('FX*.xml')
Folder:
Load '$(File)' as Name,
date#(keepchar('$(File)','0123456789'),'YYYYMMDD') as FileDate
autogenerate 1;
next File
LatestFile:
first 1
Load
Name,
FileDate,
1 as dummy
Resident Folder
Order By FileDate DESC;
drop table Folder;
LET varLatestFile = PEEK('Name' , 0, 'LatestFile');
drop table LatestFile;
addon:
load * from Addondemo.qvd (qvd);
concatenate (addon) LOAD ProdNr
FROM $(varLatestFile) (XmlSimple, Table is [Tickets/Ticket/Order/Line/Addon]);
Store Addon into Addondemo.qvd;
etc...
Can you show me in the qlikview script, i don't understand this.
and send it as attachment.
thanx
See attached qvw.
Gijsbert,
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.
anton