Does LastValue only work with strings?

[#1]

Hi,

In my load script, I'm trying to capture the last value (in load order) of a numeric field using the LastValue function (I've also tried FirstSortedValue with a negative sort-weight) but it only seems to work with non-numeric data. The help text seems to back this up stating that "If no text value is found, NULL is returned."

Is this correct and if so is there an equivalent numeric function?

Thanks all,

Rich

[#2]

hi richhoos

I'm not really sure that I understand what you need, but I you want to capture a value , I think that peek() will do great.

In your situation : peek('your table',-1)

I hope it will help you,

Will

[#3]

I've figured it out!

The last value was null. It DOES work with numeric data.