copy rows in data loader

[Ethel]

Hi, could you please help me.

I have several qvd tables . In each table I have I have column1,column2, column3 and column year. Max year is table1 is 2020.

Max year in table2  is 2021 etc. All tables have different max years in column year.

I need to copy all rows from the tables that are greater than max year and less or equal than current year(2022) and concatenate them with my tables.

So, for table1 I need to copy rows for years 2021,2022.  and add these rows to my table1

For table2 I need to copy row for year 2022 and add it to my table 2 etc.

Thank you very much in advance!