retrieve value from first record in table and store in variable

[KUNGFUPANDA559]

I seem to be having issues storing record value to variable.  

datasource.desired_field=123456789012345

varFinalValue should equal "123456789012345" not a table.  

Thoughts?

set(varFinalValue,Value(datasource.desired_field))

datasource: SQL

datatype: varchar(15)

[RezaDorrani · Accepted solution]

Hi @KUNGFUPANDA559 

set(varFinalValue,Value(datasource.desired_field))

will return a table because your are getting all records for data source with column desired_field

you can either get first value from collection

set(varFinalValue,Value(First(datasource).desired_field))

or lookup data based on condition

set(varFinalValue,Value(Lookup(datasource,condition).desired_field))

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[KUNGFUPANDA559]

this is exactly what I was looking for thanks @RezaDorrani