title: Azure Streaming Analytics Query Pivot table without aggregation
body: <p>I have the following json input from EventHub:</p>
  <pre><code>{&quot;MeasurementReading&quot;:
  [{&quot;TimeStamp&quot;:&quot;2017-02-23T07:08:49&quot;,&quot;Tag&quot;:&quot;Tag1&quot;,&quot;Value&quot;:&quot;1&quot;,&quot;Good&quot;:&quot;true&quot;,&quot;Questionable&quot;:&quot;false&quot;,&quot;Substituted&quot;:&quot;false&quot;},
  {&quot;TimeStamp&quot;:&quot;2017-02-23T07:08:49&quot;,&quot;Tag&quot;:&quot;Tag2&quot;,&quot;UnitsAbbreviation&quot;:&quot;&quot;,&quot;Value&quot;:&quot;2&quot;,&quot;Good&quot;:&quot;true&quot;,&quot;Questionable&quot;:&quot;false&quot;,&quot;Substituted&quot;:&quot;false&quot;},
  {&quot;TimeStamp&quot;:&quot;2017-02-23T07:08:49&quot;,&quot;Tag&quot;:&quot;Tag3&quot;,&quot;UnitsAbbreviation&quot;:&quot;&quot;,&quot;Value&quot;:&quot;3&quot;,&quot;Good&quot;:&quot;true&quot;,&quot;Questionable&quot;:&quot;false&quot;,&quot;Substituted&quot;:&quot;false&quot;},
  {&quot;TimeStamp&quot;:&quot;2017-02-23T07:08:49&quot;,&quot;Tag&quot;:&quot;Tag4&quot;,&quot;UnitsAbbreviation&quot;:&quot;&quot;,&quot;Value&quot;:&quot;4&quot;,&quot;Good&quot;:&quot;true&quot;,&quot;Questionable&quot;:&quot;false&quot;,&quot;Substituted&quot;:&quot;false&quot;},
  {&quot;TimeStamp&quot;:&quot;2017-02-23T07:08:49&quot;,&quot;Tag&quot;:&quot;Tag5&quot;,&quot;UnitsAbbreviation&quot;:&quot;&quot;,&quot;Value&quot;:&quot;5&quot;,&quot;Good&quot;:&quot;true&quot;,&quot;Questionable&quot;:&quot;false&quot;,&quot;Substituted&quot;:&quot;false&quot;},
  {&quot;TimeStamp&quot;:&quot;2017-02-23T07:08:49&quot;,&quot;Tag&quot;:&quot;Tag6&quot;,&quot;UnitsAbbreviation&quot;:&quot;&quot;,&quot;Value&quot;:&quot;6&quot;,&quot;Good&quot;:&quot;true&quot;,&quot;Questionable&quot;:&quot;false&quot;,&quot;Substituted&quot;:&quot;false&quot;}]}
  </code></pre>
  <p>I would like write a query within the Streaming Analytic that would pivot the table that would produce the following table:</p>
  <blockquote>
  <p>TimeStamp,            Tag1,    Tag2,  Tag3,   Tag4, Tag5,    Tag6</p>
  <p>&quot;2017-02-23T07:08:49&quot;,1       ,2,     3,      4,    5,       6</p>
  </blockquote>
  <p>I have tried to solves this for a day no with no luck, I would appreciated any help.</p>