# Query binding transform: extract data from dataset

**URL:** <https://forum.inductiveautomation.com/t/query-binding-transform-extract-data-from-dataset/87956>\
**Category:** Ignition\
**Created:** [March 27, 2024, 10:57am UTC](https://forum.inductiveautomation.com/t/query-binding-transform-extract-data-from-dataset/87956 "2024-03-27T10:57:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Francesco\_Vittadini](https://avatars.discourse-cdn.com/v4/letter/f/9dc877/32.png) [@Francesco\_Vittadini](https://forum.inductiveautomation.com/u/Francesco_Vittadini)\
**Post date:** [March 27, 2024, 10:57am UTC](https://forum.inductiveautomation.com/t/query-binding-transform-extract-data-from-dataset/87956/1 "2024-03-27T10:57:22Z")

</div>

Hello  
i'm stuck in searching and cannot find a post. Perhaps just wrong searching  
I have a named query which is giving following result:

[{"substring":"2024-02-09","payern1":"User Info"}]

I need to use 2024-02-09 in a label and User Info in another. I know there is a fast solution but I'm not able to find it.

Thanks to everybody

---

<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:** [March 27, 2024, 11:04am UTC](https://forum.inductiveautomation.com/t/query-binding-transform-extract-data-from-dataset/87956/2 "2024-03-27T11:04:08Z")

</div>

> [@Francesco\_Vittadini](#):
>
> [{"substring":"2024-02-09","payern1":"User Info"}]

Bind each label to the query and use an expression transform in each.  
`{value}[0]['substring']`  
`{value}[0]['payern1']`

How it works:  
The query is returning a list (array) signified by the `[]`. We access the dictionary by the list index `[0]`.  
The list contains only one element, a dictionary with two key-value pairs. You retrieve the value by referencing the `['key']`.

---

<div class="post-metadata">

**Author:** ![Francesco\_Vittadini](https://avatars.discourse-cdn.com/v4/letter/f/9dc877/32.png) [@Francesco\_Vittadini](https://forum.inductiveautomation.com/u/Francesco_Vittadini)\
**Post date:** [March 27, 2024, 11:21am UTC](https://forum.inductiveautomation.com/t/query-binding-transform-extract-data-from-dataset/87956/3 "2024-03-27T11:21:44Z")

</div>

thanks man  
it works perfectly  
Just to know: what if I'll need to do it using a script transform?

---

<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:** [March 27, 2024, 11:28am UTC](https://forum.inductiveautomation.com/t/query-binding-transform-extract-data-from-dataset/87956/4 "2024-03-27T11:28:09Z")

</div>

Show your use case when the time comes. We'll be all over it!