load latest 4 years

[AtheerYahya]

Hi,

I have 13 years in "Years" column but i need to load only the latest 4 years in load editor.

 Years column:

Years
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021

i need to load:

Years

2018

2019

2020

2021

if we are in 2022, the Years loaded should be:

Years

2019

2020

2021

2022

and so on. Thanks

[MayilVahanan]

Hi

I hope always your data is upto Yesterday or Today. 

In that case, try like below

Load * from yoursourcedata where Year >= Year(Today()-1)-4;

[AtheerYahya]

Hello,

thanks for your reply!

when i loaded it, it did not display any records.

here is my code:-

[MoamalatComplianceDepartment]:
LOAD Subject,
TransactionId,
Years;

SQL SELECT Subject,
TransactionId,
Years,
FROM x;

Store [MoamalatComplianceDepartment] into [lib://Qvds (xxx)/xxx.qvd](qvd);

Drop Table [MoamalatComplianceDepartment];

[MoamalatComplianceDepartment]:
LOAD Subject,
TransactionId,
Years
FROM [lib://Qvds (xxx)/xxx.qvd](qvd) where Years >= Year(Today()-1)-4;

[MayilVahanan]

Hi

Its looks good. Please send the sample data or app?