# Changelog of Join Datasets: VLOOKUP & Merge Two Datasets or CSV Files (`humble-echidna/dataset-join`) Actor

- **URL**: https://apify.com/humble-echidna/dataset-join/changelog.md
- **Full Actor documentation**: https://apify.com/humble-echidna/dataset-join.md

## Changelog

Versions follow MAJOR.MINOR.PATCH (`src/version.py`); Apify shows MAJOR.MINOR from `.actor/actor.json`.
Every run logs its version and records it in the `RUN_STATS` key-value record.

### 0.1.1 (2026-10-04)

- README: the ready-to-run Store examples.

### 0.1.0 (2026-10-04)

First release.

- Joins main data (an Apify dataset, or a CSV/TSV, JSON, JSON Lines or Excel file at a URL) with lookup data (the same
  kinds) on one or more key pairs (`field` or `main = lookup`, nested paths allowed), like VLOOKUP or a SQL join.
- Matching as text (case, extra spaces and accent encoding ignored; 12 = "12"), exactly, or by website domain (URLs,
  bare domains and email addresses).
- Left, inner and anti joins; the first lookup row per key, or one output row per match.
- Lookup fields picked and renamed, an optional prefix, `lookup_<name>` for names the main row already has, null-filled
  columns for unmatched rows, and a `joinMatched` field.
- Fails before writing anything when no lookup row, or none of the first 100 main rows, has the join field.
- Charged per output row (`apify-default-dataset-item`); max rows per run and the maximum cost per run stop the run.
- Limits: 200,000 lookup rows within half of the run's memory, 1,000,000 main rows, 200 MB files, 5 MB output rows.