Combine kept runs on the same places
combine_runsJoin two to 6 kept runs (run_ids from earlier answers, or tables such as dated tabs in Drive) on the place ID every tool returns (record_key), each run's columns kept separate under its name, and say what changed between the first and last run for the columns named in compare: "sites whose nearest A&E got further away since September". Places in only some runs are kept and say which; only_changed returns just the rows that changed. Up to 5,000 rows a run; the first 300 combined rows come back.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | No | The place ID column every run has. | record_key |
| runs | Yes | Oldest first. | |
| columns | No | Only these columns from each run (default: all). | |
| compare | No | Columns to compare between runs: numbers get the change, text whether it changed. | |
| only_changed | No |