Forum Discussion
Question about pivoting timeseries
Hi dariva,
Based on my test with your sample data, we can select the Tag column then click on Pivot Column button, set the returned values from Value column. For more information, see attached sample.
Best Regards,
Qiuyun Yu
amitchandak v-qiuyu-msft
After I post the question I tried this operation with this mock data I presented. But whit the actual data I am having some weird behavior. I think it worth trying to explain it.
1) In the original dataset I have one entry every minute for each tag and each tag has as numerical (int) ID. If I use the ID instead of the tag the pivoting works perfectly. But using the tag (string) I receive that error message I show.
2) Doing some test I found the following. If I filter the time column in the data table to keep just some minutes the pivoting using the tag works! I increased the amount of time until I reached a limit of 55 minutes (+/-) when the problem start happening.
Finally I manage to obtain my desired result in a not very elegant way. I did the following.
1) I pivoted the data table in the using the time column
2) I unpivoited the previous pivoted table
3) I them pivoted the previous unpivoted table using the tag column! (and it worked!!!).
Regards,