toggle the Enable Unnest button to open the dialogue boxes
| boxes to fill in | type of box | what is in the drop-down menu? | what is this? what kind of information goes there? how do we know what to choose? |
|---|---|---|---|
| ID Variables | drop-down menu | previously existing entities | |
| Columns to keep as-is | drop-down menu | previously existing entities | |
| Columns to unpivot | free-form | ||
| Name for the new column containing variable names | free-form | ||
| Unnest: | |||
| locations have multiple levels: country, parish and village, all of which are location types. So turn all three columns into two: one showing location type, one with the name of the location |
so keep ID (and other important columns as is) and call the value variables country, parish, and village, all of which will wind up under location
- make a figure explaining this!
Next: 2.1.5 Append Tab