press the + ADD EXTRA COLUMNS button to open the dialog boxes
Use this tab to create the additional columns that the dataset will need for ingestion. This is particularly useful for columns that apply to an entire dataset, such as assigning an analysis method, or a country location.
| boxes to fill in | type of box | what to put here |
|---|---|---|
| New Column Name | free-form | the name of your new column |
| Expression | free-form | enter a formula or value that will fill the column with the appropriate information |
It can also be used to help pull out data that only appears in some of the rows of the dataset.
For example, imagine a dataset where some of the sites have a lämningsnummer (The Swedish National Heritage Board’s national site identifier number).
- Create a data-derived entity from the source dataset called site_property (with a public ID of site_property_id)
- In the Columns box select the column lämningsnummer
- In the Extra Column Tab: create a new column called site_property_type_id and set its Expression to 1. This will add that column to the dataset, and for every row that there is information in the lämningsnummer column, then the new column will have a value of 1.
This can be done in conjunction with creating a fixed value entity called site_property_type which adds a column (in the column box on the Basic tab) called site_property_name, plus two manually created rows (+ ADD ROW button), with “National site identifier” in row 1. subsequent rows would be added for any other site property names relevant to the dataset, and entities to define them would be created.
Next: 2.1.7 YAML Tab