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 | Number of Dogs | 0
# schema I'm trying to create
ID | Name | Type | Field Name 1 | Field Value 1 | Field Name 2 | Field Value 2
1 | Post 1 | post | Number of Cats | 2 | Number of Dogs | 0
2 | Post 2 | post | NULL | NULL | NULL | NULL
Would anyone have an idea of how to create this via a DOMO ETL or some other mechanism?