Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Just wondering what is the best way/ best practices to load data based on a specific date. I need to do this as my dataset is too large and I am experiencing memory errors.
I want to look at everything after 2018. See my attempt below.
Any help much appreciated as always 🙂
LOAD RECORD_ID,
ID,
NAME,
STATUS,
PRODUCT_ID,
Date(Date#(DATETIME_CREATED,'DD/MMM/YYYY hh:mm:ss')) > Date(Date#('31/12/2018 12:00:00', 'DD/MMM/YYYY hh:mm:ss'));
This can be done usually with a simple WHERE clause in your load statement.
What is the current format of the Field, DATETIME_CREATED?
This can be done usually with a simple WHERE clause in your load statement.
What is the current format of the Field, DATETIME_CREATED?