Skip to main content
Adds new rows to the existing table without modifying existing data. No deduplication is performed, so you may end up with duplicate records.
This strategy is best used when unique keys aren’t required. For key-based updates, use one of the Merge options instead.

​
Example: Add daily trips

Daily trips are appended so that historical trips remain intact.
Incoming table
TRIP_IDVEHICLE_IDDATE
3012012024-01-15
3022022024-01-15
Existing table
TRIP_IDVEHICLE_IDDATE
1011012024-01-14
1021022024-01-14
Updated table
TRIP_IDVEHICLE_IDDATE
1011012024-01-14
1021022024-01-14
3012012024-01-15
3022022024-01-15
Notice that the new trips (301 and 302) are added to the existing table without modifying the original records (101 and 102).