# rotateDataset() and sortDataset() function

**URL:** <https://forum.inductiveautomation.com/t/rotatedataset-and-sortdataset-function/5938>\
**Category:** Ignition\
**Created:** [February 28, 2013, 8:13am UTC](https://forum.inductiveautomation.com/t/rotatedataset-and-sortdataset-function/5938 "2013-02-28T08:13:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [February 28, 2013, 8:13am UTC](https://forum.inductiveautomation.com/t/rotatedataset-and-sortdataset-function/5938/1 "2013-02-28T08:13:07Z")

</div>

HI,

When dealing with dataset for reporting or interfacing other system, it is usual to have to pivot dataset. I know some database can handle this quite nicely or by a magic python script, but it would be very helpful for non specialist to have those functions in script.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [February 28, 2013, 3:07pm UTC](https://forum.inductiveautomation.com/t/rotatedataset-and-sortdataset-function/5938/2 "2013-02-28T15:07:04Z")

</div>

[system.dataset.sort()](http://inductiveautomation.com/support/usermanuals/ignition/system_dataset_sort.htm) already exists ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")

---

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [February 28, 2013, 3:14pm UTC](https://forum.inductiveautomation.com/t/rotatedataset-and-sortdataset-function/5938/3 "2013-02-28T15:14:25Z")

</div>

Yes, I saw that a few minutes later…