Set field range in load script

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

Don't load the data older than 2010

LOAD stuff

FROM somewhere

WHERE year >= 2010;

[#3]

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?

[#4]

I believe I just answered my own question. As you said, place "Where..." statement after FROM line. Thanks!