Create variable from a table value

[Felipe02]

Gentlemen, is it possible to place the value of a table in a variable?

I need to use an existing value in a table, and it does not have a connection link with other tables in the application.

[Lech_Miszkiewicz · Accepted solution]

HI, 

since it is a table from your data model you can just load it during load script. 

Let vYourVariable = Peek('YourField', 0, 'YourTable'); // 0 is a first row in that table 

If your table has many rows and you want users to pick value from UI by selecting single value in your table you can just use "=Only(YourField)" or "'MaxString(YourField)" or similar (depending what your value actually is) formula which will make it dynamic to user selections.

cheers

[Felipe02]

Thanks friend, this solved my problem!

[Justin-Katz]

How would you do this if the source was a table in the UI? Is it possible?