title: How to expand array values stored as properties in Kusto
body: <p>I have a property bag (json object) that unfortunately has an array of objects by dynamically named properties, rather than an actual array. There are other properties in the bag as well. For example:</p>
  
  <pre><code>{
    "something": "whatever",
    "another": "doesn't matter",
    "thing1": "value1",
    "thing2": "value2",
    "thing3": "value3"
  }
  </code></pre>
  
  <p>Ultimately I'd like to have one row per <code>thing</code>:</p>
  
  <pre><code>value1
  value2
  value3
  </code></pre>
  
  <p>I know I can use <code>mv-expand</code> to convert an array or property bag into multiple rows, but I'm not sure how to</p>
  
  <ol>
  <li>Keep only the properties where key starts with "thing"</li>
  <li>Discard the key, keeping only the value</li>
  </ol>
  
  <p>In case it's important, the number of things per property bag varies greatly. Usually it's only one, but sometimes it's 10-20 and rarely it could be 100 or more.</p>