# Loop through dataset and add new column in same dataset that list how many time an item occured in each loop

**URL:** <https://forum.inductiveautomation.com/t/loop-through-dataset-and-add-new-column-in-same-dataset-that-list-how-many-time-an-item-occured-in-each-loop/99183>\
**Category:** Ignition\
**Created:** [November 27, 2024, 2:28pm UTC](https://forum.inductiveautomation.com/t/loop-through-dataset-and-add-new-column-in-same-dataset-that-list-how-many-time-an-item-occured-in-each-loop/99183 "2024-11-27T14:28:04Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 27, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/loop-through-dataset-and-add-new-column-in-same-dataset-that-list-how-many-time-an-item-occured-in-each-loop/99183/5 "2024-11-27T14:35:47Z")

</div>

Show us your SQL query. Please see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831).

---

_[View the full topic](https://forum.inductiveautomation.com/t/loop-through-dataset-and-add-new-column-in-same-dataset-that-list-how-many-time-an-item-occured-in-each-loop/99183)._