Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I have a database with data for 5 years and I need to only load data from 8/1/2008 forward. Where and how in the script can I do this? TIA!
You can use where clause:
SET DateFormat='DD/MM/YYYY';
tmp:
Load * Inline [
Date
8/1/2005
8/1/2008
8/1/2012
];
NoConcatenate
Load * Resident tmp Where Date>='8/1/2008'; DROP Table tmp;
Hi @cwhittington05 have you seen this post Load Where?
We have lots of examples in our community that could match your need.
I hope this specific one helps.