peek function?

Report Inappropriate Content · ‎2014-02-13

Load Field, Value,

A1, 12

B1, 13

C1 14

how can i use the peek function to get the value for c1 even if i move c1 up to the first row in the data sheet..

Report Inappropriate Content · ‎2014-02-13

Not sure why we need to use Peek() here. Once the table is reloaded C1 will always be associated with 14. Maybe you can elaborate a little.

Thanks

AJ

Nicole-Smith · ‎2014-02-13

You'll want to use the lookup() function instead:

lookup('Value', 'Field', 'C1', 'TableName')

vikasmahajan · ‎2014-02-14

PFA sample with data.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Sokkorn · ‎2014-02-14

Hi,

Alter load script, you can try in text object with this expression =Only({<Field = {'C1'}>} Value)

Regards,

Sokkorn

Related Topics