# Add Row Number to Dataset Sim aids?

**URL:** <https://forum.inductiveautomation.com/t/add-row-number-to-dataset-sim-aids/76327>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [July 13, 2023, 2:23pm UTC](https://forum.inductiveautomation.com/t/add-row-number-to-dataset-sim-aids/76327 "2023-07-13T14:23:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rfolkes](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\
**Post date:** [July 13, 2023, 2:23pm UTC](https://forum.inductiveautomation.com/t/add-row-number-to-dataset-sim-aids/76327/1 "2023-07-13T14:23:16Z")

</div>

Want to add the row number to a dataset.

Col  
A, B, C

becomes

Col  
A, B, C, D

with the value in Col D = the row number

I thought I could do something like

`View("Select *, Row_Number()", Dataset)` but that doesn't work.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 13, 2023, 2:36pm UTC](https://forum.inductiveautomation.com/t/add-row-number-to-dataset-sim-aids/76327/2 "2023-07-13T14:36:50Z")

</div>

```auto
selectStar({path.to.dataset}, idx(), '_rowIdx', 'I')

```

[https://www.automation-pros.com/simaids/doc/expression.selectstar.html](https://www.automation-pros.com/simaids/doc/expression.selectstar.html)

Strictly speaking, `view()` can do this too, just slower:

```auto
view("Select *, _r", {path.to.dataset})

```

[https://www.automation-pros.com/simaids/doc/expression.view.html](https://www.automation-pros.com/simaids/doc/expression.view.html)

---

<div class="post-metadata">

**Author:** ![rfolkes](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\
**Post date:** [July 13, 2023, 2:42pm UTC](https://forum.inductiveautomation.com/t/add-row-number-to-dataset-sim-aids/76327/3 "2023-07-13T14:42:23Z")

</div>

> [@pturmel](#):
>
> `selectStar({path.to.dataset}, idx(), '_rowIdx', 'I')`

i get error Unknown function: 'idx'

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 13, 2023, 2:44pm UTC](https://forum.inductiveautomation.com/t/add-row-number-to-dataset-sim-aids/76327/4 "2023-07-13T14:44:02Z")

</div>

That function is new in V2:

> [@Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-simulation-aids-v2/74934):
>
> Automation Professionals is pleased to announce the immediately availability of a major upgrade to its free Simulation Aids Integration Toolkit module. The new feature justifying the "major upgrade" language is the implementation of eleven thirty-one new expression functions which use iteration to accomplish complex transforms of datasets and lists, to or from other datasets and lists, applying filtering, ordering, and computed new columns along the way. While there are certain operations that…

{ As is `selectStar`. }

---

<div class="post-metadata">

**Author:** ![rfolkes](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\
**Post date:** [July 13, 2023, 2:48pm UTC](https://forum.inductiveautomation.com/t/add-row-number-to-dataset-sim-aids/76327/5 "2023-07-13T14:48:50Z")

</div>

Will take a look at V2

Thanks