topic Trying to load many QVD's with the same fields in QlikView

Trying to load many QVD's with the same fields

Fri, 12 Jul 2013 14:13:33 GMT

Hi everyone,

I have a QVD to generate one QVD per day, with all the informations I need.

These information, come from Oracle Database.

For exemple:

- titles03072013.qvd

- titles04072013.qvd

- titles05072013.qvd

etc...

But, obviously, all that QVD with date, have the same fields: title_dateofpayment, title_dateofopening, title_value, etc...

If I do a LOAD * From path\*.qvd, Qlikview subscribes all the data, and keep only the data of the last day's qvd.

Have a way, to keep all the fields, loading , for example: title_value03072013, title_value04072013, title_dateofopening03072013, title_dateofopening04072013, etc...????

I have to do this, for yesterday! rs

Thanks!!

Re: Trying to load many QVD's with the same fields

Gysbert_Wassenaar — Fri, 12 Jul 2013 14:20:13 GMT

That's not a very good idea. It's better to extract the date from the filename and store that in a field:

MyData:

load *, date#(mid(filename(),7,8),'DDMMYYYY') as MyDate

from path\*.qvd (qvd);

This way you can use the MyDate field to select data by date.

Re: Trying to load many QVD's with the same fields

Fri, 12 Jul 2013 17:52:01 GMT

Thanks man!