Fiscal year - 4years

[rdsuperlike]

I have a column in my load statment as below:

FISCAL_YEAR

how do i load the data to last 4 years here ?

there is no query.It loads from a system generated csv file. So i want to restrict on load sttamenet

[sunny_talwar]

How does the FISCAL_YEAR field look like? Does it contain straight numbers?

[ramoncova06]

you can also apply a where condition to a csv file

so if the fiscal year has a format of YYYY then you could do

load

*

from .....

where FISCAL_YEAR >= 2012