I have to append a big reporting table (2 millions records) every month with data.
The problem is that the data structure has changed throughout the history, so the dataset that is appended has differnt number of columns than the reporting table.
For the moment I have solved this by loading in both tables and using the append action and then export the resulting table.
I think this is not optimal. Is there another way to do this thus increasing the performance ?
Does the append mode in export to CSV does also column mapping ?