# Add list data to table in prespective

**URL:** <https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [March 15, 2023, 12:47pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088 "2023-03-15T12:47:25Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [March 15, 2023, 12:47pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088/1 "2023-03-15T12:47:25Z")

</div>

Hi,

i have 3 list  
a = [1,2,3]  
b = ["good", "bad", "error"]  
c = ["yes", "no","none"]

how to add this 3 list to table dataset in perspective?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 15, 2023, 12:59pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088/2 "2023-03-15T12:59:25Z")

</div>

Are each of these a row or a column?

---

<div class="post-metadata">

**Author:** ![Dalton\_Adams](https://avatars.discourse-cdn.com/v4/letter/d/7c8e57/32.png) [@Dalton\_Adams](https://forum.inductiveautomation.com/u/Dalton_Adams)\
**Post date:** [March 15, 2023, 1:51pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088/3 "2023-03-15T13:51:10Z")

</div>

You could try something like this.

```auto
a = [1,2,3]
b = ["good","bad","error"]
c = ["yes","no","none"]

headers =["a","b","c"]
data = []
i = 0
for i in range(0,3):
	data.append([a[i],b[i],c[i]])
test = system.dataset.toDataSet(headers,data)
print test

```

This might not fit your use case, but I hope this helps!  
Thanks,

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [March 15, 2023, 1:57pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088/4 "2023-03-15T13:57:44Z")

</div>

one list is one column so i should have 3 columns

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 15, 2023, 2:47pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088/5 "2023-03-15T14:47:00Z")

</div>

Take a look at [system.dataset.addColumn()](https://docs.inductiveautomation.com/display/DOC81/system.dataset.addColumn)

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [March 15, 2023, 3:02pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088/6 "2023-03-15T15:02:38Z")

</div>

[quote="Dalton\_Adams, post:3, topic:71088"]

```auto
a = [1,2,3]
b = ["good","bad","error"]
c = ["yes","no","none"]

headers =["a","b","c"]
data = []
i = 0
for i in range(0,3):
	data.append([a[i],b[i],c[i]])
test = system.dataset.toDataSet(headers,data)
print test

```

its working for prespective too thanks

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [March 15, 2023, 3:10pm UTC](https://forum.inductiveautomation.com/t/add-list-data-to-table-in-prespective/71088/8 "2023-03-15T15:10:15Z")

</div>

@JordanCClark

In perspective it's returning dataset in array type

how to do that  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/a/baf3393762da2b70e74e5f827fca8c78e363b182.png)