Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Load qvd file then the last xml files

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Load qvd file then the last xml files

See attached qvw.


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Load qvd file then the last xml files

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


talk is cheap, supply exceeds demand
Not applicable

Re: Load qvd file then the last xml files

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

and send it as attachment.

thanx

MVP & Luminary
MVP & Luminary

Re: Load qvd file then the last xml files

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Load qvd file then the last xml files

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