Load FieldIndex('First name','John') as MyJohnPos//This gives 1
Load FieldIndex('First name','Peter') as MyPeterPos //This gives 4
My question is the following: is there a way to find the index (or directly find the value) of the last occurrence of the name? What I'd like to say is wheter there's a way to have MyPeterPos = 6 instead of 4.
that was just an example, I've got a bigger algorithm that load rows from a huge table and I'd like to find a function (or a composition of functions) to perform that task. Do you know if exist something like that?
I don't think FieldIndex can handle this, but may be an alternative like what cleveranjos pointed out... but it might be easier to see why his solution doesn't work if you can provide a more detailed explanation of what you are looking to do
cleveranjos stalwar1 rwunderlich thank you guys for your help, as you suggested to me I firstly did a preliminary load of the table and then I used a combination of Lookup funcion, variables, RowNo and fieldindex to get everything work.