Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I do have a below year field which has data from 2019.
Year |
2019 |
2020 |
2021 |
now my requirement is to create a new field in the load script to get only current year and previous year. It means currently it is 2021 so I want 2021 and 2020 only in that field and next year is 2022 so that field has to capture only 2022 and 2021.
Hi,
It should works with :
TAB1:
LOAD * INLINE [
ANNEE
2017
2018
2019
2020
2021
]
where ANNEE=year(today()) or ANNEE=year(today())-1;