title: Transforming a list of objects into a table in Kusto
body: <p>I am trying to get the json data (in form of a list of key-value pairs) in one of my data table cells and convert that into a dynamic table of sorts.</p>
  
  <pre><code>T
  | where id == "xyz"
  | project telem_obj
  </code></pre>
  
  <p>The data in the telem_obj cell is of the format</p>
  
  <p>[
    {
      "Value": "SomeKey01",
      "Key": "0"
    },
    {
      "Value": "SomeKey02",
      "Key": "1"
    }
  ]</p>
  
  <p>My end objective is to get a table of the form;</p>
  
  <pre><code>|Key         | Value |
  |SomeValue01 | 0     |
  |SomeValue02 | 1     |
  </code></pre>
  
  <p>I have managed to do this by taking out the static data and creating atable out of it.</p>
  
  <pre><code>print EnumVals = dynamic(
      [
        {
          "Value": "SomeKey01",
          "Key": "0"
        },
        {
          "Value": "SomeKey02",
          "Key": "1"
        }
      ]
  )
  | mvexpand EnumVals
  | evaluate bag_unpack(EnumVals)
  </code></pre>
  
  <p>I am not sure how can I go about taking result of my query, extracting this list of json objects from it and convert it into a new dynamic table. I cannot find any example which works on a list of objects.</p>