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!