04 / Organize
Finer levels roll up so sources meet at the right one.
Finer levels roll up so sources meet at the right one.
Example
| Raw value | Source level | Shared join level |
|---|---|---|
| New York County | county | state: New York |
| NY | state | state: New York |
| New York | state or city? | waits for review |
Use it when one source reports by state and another by county, or datasets use different hierarchy levels.
Hierarchy.
“New York” is a state and a city. One source reports by state, another by county, and nothing says which.
Hierarchy-aware joins.
Stable IDs, hierarchy levels and aliases for places, industries and vendors. Store sales by state and population by county now join at state level.