Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a year field that goes from 2001-2025. Is there a way to limit the field to 2010 to 2025 in the load script?
Thanks
Don't load the data older than 2010
LOAD stuff
FROM somewhere
WHERE year >= 2010;
Don't load the data older than 2010
LOAD stuff
FROM somewhere
WHERE year >= 2010;
Hi Gysbert,
The Year field is part of a larger table load, like:
LOAD
Platform Name
Year,
Amounts
From
XYZ.qvd;
Can I modify the Year field in there, or do I have to do it separately?
I believe I just answered my own question. As you said, place "Where..." statement after FROM line. Thanks!