Load qvd file then the last xml files

[#1]

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.

[Gysbert_Wassenaar]

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...

[#3]

Can you show me in the qlikview script, i don't understand this.

and send it as attachment.

thanx

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#5]

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