Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ethel
Creator III
Creator III

copy rows in data loader

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!

0 Replies