Pricing

from $2.00 / 1,000 joined rows

Try for free

Go to Apify Store

Dataset Join & Merge (VLOOKUP for Datasets)

Try for free

Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields like SQL or VLOOKUP: left, inner, right, full and anti joins plus union, with CSV/Excel export, named-dataset append and webhook delivery. Agent-ready: pay per event (x402, MCP), per output row.

Pricing

from $2.00 / 1,000 joined rows

Rating

0.0

(0)

Developer

Adam Pearce

Actor stats

Bookmarked

Total users

Monthly active users

5 days ago

Last modified

Categories

Developer tools

Automation

Agents

You can access the Dataset Join & Merge (VLOOKUP for Datasets) programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "leftData": [
10        {
11            "email": "ana@example.com",
12            "name": "Ana Silva",
13            "company": "Silva Ltd",
14        },
15        {
16            "email": "BEN@example.com",
17            "name": "Ben Okafor",
18            "company": "Okafor & Co",
19        },
20        {
21            "email": "cara@example.com",
22            "name": "Cara Lind",
23            "company": "Lind Studio",
24        },
25        {
26            "email": "dev@example.com",
27            "name": "Dev Patel",
28            "company": "Patel Group",
29        },
30    ],
31    "rightData": [
32        {
33            "email": "ana@example.com",
34            "plan": "Pro",
35            "mrr": 49,
36        },
37        {
38            "email": "ben@example.com ",
39            "plan": "Starter",
40            "mrr": 19,
41        },
42        {
43            "email": "dev@example.com",
44            "plan": "Pro",
45            "mrr": 49,
46        },
47        {
48            "email": "erin@example.com",
49            "plan": "Enterprise",
50            "mrr": 499,
51        },
52    ],
53    "leftKeyFields": ["email"],
54}
55
56# Run the Actor and wait for it to finish
57run = client.actor("nerolabs/dataset-join-merge").call(run_input=run_input)
58
59# Fetch and print Actor results from the run's dataset (if there are any)
60print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
61for item in client.dataset(run.default_dataset_id).iterate_items():
62    print(item)
63
64# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Dataset Join & Merge - VLOOKUP / SQL Join for Datasets API in Python

The Apify API client for Python is the official library that allows you to use Dataset Join & Merge (VLOOKUP for Datasets) API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Dataset Join & Merge (VLOOKUP for Datasets) API in JavaScript

Dataset Join & Merge (VLOOKUP for Datasets) API through CLI

Dataset Join & Merge (VLOOKUP for Datasets) OpenAPI definition

Dataset Join & Merge (VLOOKUP for Datasets) API

Dataset Diff & Change Detector

nerolabs/dataset-diff-detector

Returns what was added, removed or changed between two Apify datasets, files or Google Sheets by URL, or JSON arrays, matched by key, field by field, or since its own last run (snapshot mode). CSV/Excel diff report, named-dataset change log, webhook delivery. Agent-ready: pay per event (x402, MCP).

Adam Pearce

Dataset Cleaner & Exporter

nerolabs/dataset-cleaner-exporter

Returns a deduplicated, flattened and cleaned copy of any Apify dataset, file or Google Sheet by URL, or JSON array, plus CSV and Excel files, named-dataset append and webhook delivery. Inputs: source, dedup keys, flatten, cleaning options. Agent-ready: pay per event (x402, MCP), per cleaned record.

Adam Pearce

Dataset Join and Enrichment

eager_vitamin/apify-dataset-join-enrichment

Join and enrich two Apify datasets by URL, ID, or another stable key with bounded, collision-safe output.

Lau Kuan Ee

Dataset Filter & Transform

nerolabs/dataset-filter-transform

Returns rows of any Apify dataset, CSV/Excel/JSON file URL or Google Sheet that pass filter rules (25 operators, AND/OR) after transforms (rename, cast, compute, regex, dates, replace, split, hash), then sort, dedupe, limit, export CSV/Excel or webhook. Agent-ready: pay per event (x402, MCP).

Adam Pearce

SQL on Files (JSON, CSV and more)

web.harvester/sql-on-files-json-csv-and-more

Run SQL queries on CSV, JSON, and Parquet files using DuckDB. No database setup required. Upload files, provide URLs, or query Apify Datasets directly. Full SQL support: JOINs, aggregations, window functions. Export as JSON, CSV, or Parquet. Lightning-fast analytical queries.

Web Harvester

Dataset Aggregate, Group By & Pivot

nerolabs/dataset-aggregate-pivot

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON array: count, sum, average, min, max, median per group, date buckets, pivot columns. Exports CSV/Excel, appends to a named dataset, posts to a webhook. Agent-ready: pay per event (x402, MCP), per input row.

Adam Pearce

Dataset Toolkit — Dedupe, Merge, Clean, Diff

glueworks/dataset-toolkit

Post-process any Apify dataset: remove duplicates, merge multiple datasets, clean and normalize fields, or diff two crawls. Outputs a new dataset plus a summary record.