JSON Transformation

[panda2004]

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"
		}	
	]
}

[Anonymous · Accepted solution]

Have you checked following video?

https://m.youtube.com/watch?v=ipI6mrWLQKA 

[panda2004]

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!).