Normalize nested JSON into multiple tables
I have a table where each row contain nested JSON. I want to normalize this JSON into multiple tables with data. For example below is the JSON for 1 row. { "Arn":"UNLQ5HFPVXMX7", "Merchant":"UNL", "Aun":"aad9561d-17bc-4280-a44f-7fd4cdb2c57a", "ExternalArn":"b7e6d3da-4b63-44a8-adfc-884cce34288d", "Status":"Commenced", "PageIdentifier":"ValidationResult", "ProductRate":{ "RollRate":false, "IsFromRate":false…