XML into Rows - Pivot each record

[SNik]

Hi

I have 100s of records that looks like as mentioned in each row.....

{
                                                "@context": "http:SomeOrg.org",
                                                "@type": "Product",
                                                "name": "Product Na 01",
                                                "category": "Catagory Nav",
                                                "image": "\/media\/image\/0\/base\/ABC-01.png",
                                                "brand": "Brand B",
                                                "mainEntityOfPage": "\/en\/models\/nav\/nav01\/"
                                            }

I am trying to change the out put to

Field1    Field B                       FieldC(Product)      FieldD(Catagory)     FieldE(Band)    FieldF(img)

  A          The above XML        Product Na 01         Catagory Nav            Brand B           ABC-01.png

  B          Another XML             Product Lm 04         Catagory Lm            Brand P           XYZ-01.png

how can i split my XML to the above new fileds Field C D E F for each row

I assume you can do this in the M language, right?

Thanks

[SNik]

one last thing heads up that the XML string has lots of space on the right as seen

{
                                                "@context": "httpomeOrg.org",
                                                "@type": "Product",
                                                "name": "Product Na 01",
                                                "category": "Catagory Nav",
                                                "image": "\/media\/image\/0\/base\/ABC-01.png",
                                                "brand": "Brand B",
                                                "mainEntityOfPage": "\/en\/models\/nav\/nav01\/"
   

[SNik]

Sorry But I didn't put that funny face