title: How to convert list of dictionaries in a string column to different rows and columns in Kusto
body: <p>Here's a sample for string column, I would want to split this string column into multiple columns based on the key values of dictionary and if there are more keys, I want to make them into different rows.</p>
  <pre><code>&lt;column1&gt;: &quot;val&quot;,
  &lt;column2&gt;: &quot;for each user:[{&quot;id&quot;:1,
  &quot;Publisher&quot;:null,
  &quot;type&quot;:0,
  &quot;Identity&quot;:{
  &quot;Id&quot;:&quot;00000000-0000-0000-0000-000000000000&quot;,
  &quot;sid&quot;:&quot;134567890&quot;},
  &quot;roles&quot;:[],
  &quot;permissions&quot;:[],
  &quot;name&quot;:ABC},
  {&quot;id&quot;:1,
  &quot;Publisher&quot;:null,
  &quot;type&quot;:0,
  &quot;Identity&quot;:{
  &quot;Id&quot;:&quot;00000000-0000-0000-0000-000000000000&quot;,
  &quot;sid&quot;:&quot;134567890&quot;},
  &quot;roles&quot;:[],
  &quot;permissions&quot;:[],
  &quot;name&quot;:ABC}]&quot;
  </code></pre>
  <p>I want to trim initial string &quot;for each user:&quot; and create columns for <strong>id, publisher, type, Identity.Id, Identity.sid, roles, permissions, name</strong> and since there are two dictionaries in the above sample, I want to insert the second item into a new row.</p>
  <p>I also want column1 in the output</p>