Normalizing table containing filed in json format


I aheba question for you all:


I have a table for example link this


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:



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.