Trying to load many QVD's with the same fields

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[#3]

Thanks man!