Expand column with JSON file

[patrickmlsk]

Hey!

I want to expand three values from a field in a JSON column of a table and add these three values as new columns into the table. The javascript is constructed in the same way all the time. So as an example: 

The javascript looks like this:

{
  "type": "XXX",
  "currenttype": 0,
  "typecontent": [
    {
      "angleSide": "none",
      "direction": "none",
      "size": {
        "x": XXX,
        "y": XXX,
        "z": XXX
      },
      "sizeTop": {
        "x": XXX,
        "y": XXX,
        "z": XXX
      },
      "sizeOuter": {
        "x": XXX,
        "y": XXX,
        "z": XXX
      },
      "materials": {
        "front": "XXX",
        "back": "XXX",
        "top": "XXX"
      },
      "typearticlenumber": "XXX",
      "articlenumber": "XXX",
      "elements": [

etc. ... 

The three values that are of importance are: "front", "back", "top". So ideally the table should look like this:

Thanks for the help!

[v-yuta-msft · Accepted solution]

@patrickmlsk ,

After import the json file, you can click list-> Record-> Record(Material)s, then click "Into Table", click column "Name" column, then click Transform-> Pivot Columns.

 

The result will be like below;

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.