0

Normalizing table containing filed in json format

Hi.

I aheba question for you all:

 

I have a table for example link this

filed_name:Format

Product_id: Integer

Delivery_metod: varchar(50)

Inventory_id: Integer

Inventory_Entries: JSON

 

Inventory_entries can contain one or several entries in JSON format like this:

[{"SKU":"A","Price":"100"},{"SKU":"B","Price":""00"}]

 

Instead off one line with the json entries nested into one single field i would like to Normalize the tabel into several lines, one for each SKU.

 

Any ideas?

 

 

 

1 comment

Please sign in to leave a comment.