# Read fields from dataset tag via script

**URL:** <https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055>\
**Category:** Ignition\
**Created:** [November 25, 2018, 7:59am UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055 "2018-11-25T07:59:59Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![claudio](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@claudio](https://forum.inductiveautomation.com/u/claudio)\
**Post date:** [November 25, 2018, 7:59am UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/1 "2018-11-25T07:59:59Z")

</div>

Hello,  
I need help to read fields of a dataset tag (for example the component at row 3 and coloumn 7) using function like system.tag.read, to write them into other appropriate single tags.

Many thanks  
Claudio

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [November 25, 2018, 12:11pm UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/2 "2018-11-25T12:11:17Z")

</div>

To use a dataset tag field value you will have to read and convert to a pydataset.

> val = system.dataset.toPyDataSet(system.tag.read('PathToDataSetTag').value)  
> print val[3][7]  
> print val[2][7]  
> print val[1][7]

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [November 26, 2018, 1:53pm UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/3 "2018-11-26T13:53:44Z")

</div>

I prefer pyDatasets as well, but remember you can access the data directly in a ‘normal’ dataset:

```auto
data = system.tag.read('Dataset tag').value
print data.getValueAt(3, 7)

```

---

<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:** [November 26, 2018, 2:13pm UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/4 "2018-11-26T14:13:26Z")

</div>

I hardly ever use toPyDataSet(). The getValueAt() method is easy to use in list comprehensions, and it’s basically what happens under the hood if you do convert.

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [November 26, 2018, 2:42pm UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/5 "2018-11-26T14:42:51Z")

</div>

I primarily use it when looping over all the elements of a dataset in a `for value in values` construct - it feels much neater 🙂

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [November 26, 2018, 2:53pm UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/6 "2018-11-26T14:53:52Z")

</div>

I have just gotten so used to looping datasets that I prefer the pyDataSet format.  
Convert it once and then access or loop.

---

<div class="post-metadata">

**Author:** ![claudio](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@claudio](https://forum.inductiveautomation.com/u/claudio)\
**Post date:** [December 1, 2018, 10:28am UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/7 "2018-12-01T10:28:57Z")

</div>

thank you  
I have used your suggestion …

---

<div class="post-metadata">

**Author:** ![claudio](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@claudio](https://forum.inductiveautomation.com/u/claudio)\
**Post date:** [December 1, 2018, 10:29am UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/8 "2018-12-01T10:29:56Z")

</div>

thank you all, I have solved using your precious suggestions.  
Many thanks  
Claudio

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 16, 2020, 9:34pm UTC](https://forum.inductiveautomation.com/t/read-fields-from-dataset-tag-via-script/21055/9 "2020-04-16T21:34:28Z")

</div>

11 posts were split to a new topic: [PyDataset Performance Questions](https://forum.inductiveautomation.com/t/pydataset-performance-questions/33991)