Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
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.
Thanks man!