Joining One-to-Many relationship datasets
I have two datasets that I am trying to join together, posts and metadata. I am figuring out how to do this via a pivot. The data schema looks like the following: # post schema ID | Name | Type 1 | Post 1 | post 2 | Post 2 | post # metadata schema Object UID | Field Name | Field Value post:1 | Number of Cats | 2 post:1 |…
