Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to do incremental load? Extract date from file name for incremental
File Name:
SS_2016-01-31
SS_2016-02-01
Note:Day-1 file stored as qvd and then perform incremental load
Message was edited by: Silambarasan M
when the load the new excel and where date> max date
I'm not sure if your statement:
Date(MakeDate(SubField(SubField(FileBaseName(),'_',4),'-',1),SubField(FileBaseName(),'-',2),SubField(FileBaseName(),'-',3))) as Date
worked and it looked somehow different to your first example of the filenames but if they then use my suggestion.
Another point is the use of the variable which needs to be wrapped in single-quotes like:
Where ... > '$(vMaxDate)';
- Marcus
that is also i gave
you create the max date variable to create the max date in the script by using the peek function
example: let vmaxdate=peek(field name,-1, table name)
after that we can taken the new file to give the where date >vmaxdate
try in this way in this way you get the output
I edit the subfield value also but not works
I already create variable which you are saying..just verify my script please
I have seen another syntax-issue within the variable-creation, instead of:
Let vMaxDate=peek('Maximum ',0,Add);
it must be:
Let vMaxDate=peek('Maximum',0,'Add');
- Marcus