> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Append Row

> Always add incoming rows to the existing table

Adds new rows to the existing table without modifying existing data. No deduplication is performed, so you may end up with duplicate records.

<Info>
  This strategy is best used when unique keys aren't required. For key-based updates, use one of the
  Merge options instead.
</Info>

## Example: Append daily sales

A sales table receives a new batch of orders each day. The incoming dataset is appended to the existing table so that all historical orders are preserved.

<div class="table-example">
  **Existing target table**

  | ORDER\_ID | PRODUCT | SALE\_DATE |
  | --------- | ------- | ---------- |
  | 101       | Laptop  | 2024-01-14 |
  | 102       | Mouse   | 2024-01-14 |

  **Incoming dataset**

  | ORDER\_ID | PRODUCT  | SALE\_DATE |
  | --------- | -------- | ---------- |
  | 301       | Monitor  | 2024-01-15 |
  | 302       | Keyboard | 2024-01-15 |

  **Resulting target table**

  | ORDER\_ID | PRODUCT  | SALE\_DATE |
  | --------- | -------- | ---------- |
  | 101       | Laptop   | 2024-01-14 |
  | 102       | Mouse    | 2024-01-14 |
  | 301       | Monitor  | 2024-01-15 |
  | 302       | Keyboard | 2024-01-15 |

  Prophecy appends every row from the incoming dataset to the target table without modifying or removing existing rows. In this example, orders `301` and `302` are added while orders `101` and `102` remain unchanged.
</div>