How do I display the value of a table cell in a label

[nagar]

I have setup this SQL query that returns only one record with one column (called email).
How can I display the result (first row, email column) inside a label?

This should be something like
{{myquery.data[0][email]}} but I'm not sure of the syntax.

Thank you.

[edurmush]

Hello @nagar,

First you have to convert your data to array formatDataAsArray(myquery.data)[0].email or use Transform result feature as simpler solution.

[nagar]

That works beautifully. Thank you so much!