Data Joiner

The Data Joiner combines two or more datasets into one. It has two actions, for two different jobs.

Open it from the Plugins button (the flask icon at the left of the farm map), which is shown to the farm's Owner, Administrators and Editors on a desktop or tablet. The plugin opens as a full page; Back to farm returns to the map.

#Steps

1. Choose the datasets to combine. With two or more chosen, two actions appear.
2. Pick the action that fits:
   • Stack N Datasets makes one dataset with every point from each, and adds a column saying which dataset each point came from. Use it for the same survey in different years, such as a virus count each season. If the dataset names contain years, the column is called Year and filled in for you. The result is saved already coloured by that column.
   • Join N Datasets lines up different measurements taken at the same coordinates, giving each point the columns of all the datasets. Use Merge Headers to combine columns that mean the same thing.
3. Name the result and save it.

Join needs data columns to work with. Datasets that only record locations cannot be joined; stack them instead.

#Video

The video was recorded on an earlier version of the plugin, so the screens look different; the idea is the same.