# Copy data from dataset editor into perspective table

**URL:** <https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 22, 2024, 10:32am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196 "2024-04-22T10:32:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 22, 2024, 10:32am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196/1 "2024-04-22T10:32:32Z")

</div>

Hello!

Transforming Ignition designer proyect into Ignition Perspective.

How can I use data from dataset editor in Designer in a table in Perspective  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/2/52917f9c0e42b51e219e75342597ceac49861b19.png)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/a/ea8a0cac3a3975fc6914025f7d67de09578b1232.png)

---

<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:** [April 22, 2024, 10:57am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196/2 "2024-04-22T10:57:30Z")

</div>

> Transforming Ignition **designer** project into Ignition Perspective.

1. Do you mean that you're transforming an Ignition **Vision** project to Perspective?

2. What is the source of the data in the Dataset Editor? Is it fixed data or does it come from a query?

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 22, 2024, 10:57am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196/3 "2024-04-22T10:57:54Z")

</div>

1.-Yes  
2.-Fixed data

---

<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:** [April 22, 2024, 11:13am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196/4 "2024-04-22T11:13:06Z")

</div>

A minor shortcoming of Designer is that there is no simple way to create or paste a dataset onto a table.

Try this:

1. Copy the code below and paste it into your view or container. It will create a table with a dataset.

> **Table with dataset**
>
> ```python
> [
> {
> "type": "ia.display.table",
> "version": 0,
> "props": {
> "data": {
> "$": [
> "ds",
> 192,
> 1713783951564
> ],
> "$columns": [
> {
> "name": "id",
> "data": [
> 0,
> 0,
> 0,
> 0,
> 0
> ],
> "type": "Integer"
> },
> {
> "name": "instrument",
> "data": [
> "Piano",
> "Guitar",
> "Drumns",
> "Bass",
> "Sax"
> ],
> "type": "String"
> }
> ]
> }
> },
> "meta": {
> "name": "Table_0"
> },
> "position": {
> "basis": "400px"
> },
> "custom": {}
> }
> ]
> 
> ```

![Dataset copy](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/d/8d2773f79759ab225ecc0c030bb465a52dd647c9.png)

1. Open the Vision dataset and copy (1).
2. On the Perspective table open the dataset on `props.data` and paste in your Vision dataset (2).

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 22, 2024, 11:18am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196/5 "2024-04-22T11:18:38Z")

</div>

Paste it as Configure Script / Custom Method into my persepective table ?

---

<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:** [April 22, 2024, 11:21am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196/6 "2024-04-22T11:21:13Z")

</div>

> [@Transistor](#):
>
> ... and paste it into your view or container.

If you read the "Table with dataset" you can see that it is a table definition.  
Paste it into the Perspective view. It will create a new table with a sample dataset.

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 22, 2024, 11:24am UTC](https://forum.inductiveautomation.com/t/copy-data-from-dataset-editor-into-perspective-table/89196/7 "2024-04-22T11:24:30Z")

</div>

Great, it works! thanks Transistor.