Arranging imported data to different format

Question

Hi,&nbsp;My imported measurement data is in format below:&nbsp;Measurement &nbsp; &nbsp; &nbsp; &nbsp;MeasurementResult &nbsp; &nbsp; &nbsp; &nbsp; TimeStamptemperature &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/9/2016 6:00:00 AMhumidity &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;95 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;7/9/2016 6:00:00 AMdewpoint &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13.2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/9/2016 6:00:00 AM&nbsp;I would like to have the data in format:TimeStamp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; temperature &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;humidity &nbsp; &nbsp; &nbsp; &nbsp;dewpoint7/9/2016 6:00:00 AM &nbsp; &nbsp; &nbsp; 14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;95 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13.2&nbsp;How would I do the transformations?

bhaveshpatel · Answer

Let me walk you through the screenshots for the solution.

t2makela · Answer

Hi,&nbsp;My imported measurement data is in format below:&nbsp;Measurement &nbsp; &nbsp; &nbsp; &nbsp;MeasurementResult &nbsp; &nbsp; &nbsp; &nbsp; TimeStamptemperature &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/9/2016 6:00:00 AMhumidity &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;95 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;7/9/2016 6:00:00 AMdewpoint &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13.2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/9/2016 6:00:00 AM&nbsp;I would like to have the data in format:TimeStamp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; temperature &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;humidity &nbsp; &nbsp; &nbsp; &nbsp;dewpoint7/9/2016 6:00:00 AM &nbsp; &nbsp; &nbsp; 14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;95 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13.2&nbsp;How would I do the transformations?

v-haibl-msft · Answer

t2makela&nbsp;If you only want to show the report in your expected format. You can also use Matrix visual chart directly as below without any transformation.&nbsp;&nbsp;Best Regards,Herbert

t2makela · Answer

BhaveshPatelThanks for the detailed reply. How do I do the arrangement if I have multiple results in same kind of format?

t2makela · Answer

v-haibl-msft&nbsp;Thanks, it works, but I would like to show the data in line chart or line and stacked column chart.

Forum Discussion

Arranging imported data to different format

6 Replies

Related content

Arranging pages

Different schema into different destination

Need column in respective arrangement

Table relationships with ambiguous paths treated differently between DQ and Import

Re-Arranging & De-cluttering Model View