I'm facing one challenging problem while making data model.
the scenario is...
In our database, PLC system will store all the parameters of machine as one table for every day.
ie one new table will be created on 01/04/2016 as MAC_PARAM_010416,similarly for each day system will create one new table as MAC_PARAM_(DATE).
Now i needs to load the data from these table in to qvd on daily basis , with the simple script.
Hope you guys can give ideas.
Thanks and regards,
read and store in qvd 1 year of files in loop
FOR i=0 to -365 step -1
LET vDate = Date(Today() +i, 'DDMMYY');
// change with your file name
load * from .......; // use vDate variable
store * from SourceTable into .......qvd (qvd); // "
read all your 2016 files with wildcard (* ?)
LOAD * from MAC_PARAM_????16.csv;
thanks ..it is working fine.
I have one more scenario like this..hope u can give some idea
there are few tables are newly generated in each day with some predefined prefix in my database.
ie, new tables are created in the name of "AVAIL_XXXXX"
in that XXXXX may be any in name..
in our previous scenario we have date filed in the tablename to filter our tables.
but in this current scenario, how can i identify which are all the tables are not loaded to my qvd??
it is working fine, but on the next day i should only load which are all the tables are not loaded in the previous day, how can i identify those tables from database?
is there any option to check with directory??