Hello,
I have a table with 2 columns: name and full name.
It's retool database (sql)
How to query and then use in select component a variable which is a full name?
fullName = name + surname
@Ana - Can you post some screenshots?
If you use the Mapped option in a select component you can dynamically define any field including the Value or the Label of any option based on values for that option's row. The row is stored in the {{ item }} object and has keys for each column, so you could try something like {{ item.name + " " + item.surname }}.
Curious to know if that works here, or if something different is needed.
thank you! 
works