Go to example tasks
Find rows that are missing from another file (anti join)
Keep only the rows of one table that have no match in another, e.g. leads not yet in your CRM export, or products a shop stopped listing. Here: currencies the US Treasury listed at the end of 2024 but no longer at the end of 2025.
Join Datasets: VLOOKUP & Merge Two Datasets or CSV Fileshumble-echidna/dataset-join
Country
Currency
Units per USD (2025-12-31)
A year earlier
+2 fieldsTextNumberBooleanListObject
Input
Or: main data file URL (CSV, JSON, JSONL or Excel):https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/rates_of_exchange?format=csv&filter=record_date:eq:2024-12-31&page[size]=300
Or: lookup data file URL:https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/rates_of_exchange?format=csv&filter=record_date:eq:2025-12-31&page[size]=300
Join on (the field that links them)(required):country_currency_desc
Which rows to keep:anti
Output fields
Country
Currency
Units per USD (2025-12-31)
A year earlier
Earlier rate's date
Matched
Sign up on Apify01
Create your Apify account to access the Join Datasets: VLOOKUP & Merge Two Datasets or CSV Files.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
