Incorrect fieldvalue is getting fetched while using Fieldvalue() function

[Ravi_Nagmal]

Hi All,

I have encountered an issue while using the Fieldvalue() function.

I am attempting to utilize metric logic from an Excel sheet as a variable using the Fieldvalue() function. For instance: Fieldvalue('Metrics', 100) provides the correct value from row 100. However, when I input row number as 260, the function returns values for the 258th instead of 260th rows, which is not the expected behavior.

Please help me it is very urgent.

[anat]

Fieldvalue will display the values as per load order,

so can you make order by in load script then check the output.

[Ravi_Nagmal]

@anat Thanks for your prompt reply but with order by also it is not working.

sharing screenshot of actual issue, It is getting shifted two rows above the actual ones.

[marcus_sommer]

fieldvalue() queries the distinct stored field-values from the system-tables - there is no relation to any table and there are only distinct values. If you want to query against a table you could use peek() for it.