Forum Discussion
Solved
JSON Transformation
How would you replace the following key/value paris into columns?
{
"ProductId":"88432",
"Tags":[
{
"Key":"Category",
"Value":"Electricity"
},
{
"Key":"IsNew",
"Value":true
},
{
"Key":"ShippingType",
"Value":"Worldwide"
}
]
}
Have you checked following video?
2 Replies
Have you checked following video?
Just what I needed, thanks!
For future intersted people:
- The tags is a List type.
- You have the ability to either expand each item into different column, such as Tag1.Key/Tag1.Value, Tag2.Key/Tag2.value, or either expand each item to a different row (which is pretty **bleep** cool!).
