search in table rows

[danaosjoin]

Hello,

I want to search in table rows with the following expression and return to me the first row that matches 

example: employee_code=5 and nationality='GRC'

I have already loaded a table, I don't want to run a  select/where statement at load time, I need to process the rows afterwards (hint: lookup cannot take expressions)

many thanks

Noel

[StarinieriG]

Hi,

try with firstvalue() or firstsortedvalue()

[jonathandienst]

>> the first row that matches...

"First"' in terms of what? Load order, date order or some other order?

[danaosjoin]

Lets say that i have load the following table...

LOAD employee_code, nationality;

and the rows that the table has are:

1,GRC

2,GRC

3,GRC

4,GRC

5,GRC

6,GRC

i want somehow to apply the following expression "employee_code=5 and nationality='GRC'" and return to me the first row that matches in this example is fifth row.

Best Regards

[danaosjoin]

any ideas ?