Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try with firstvalue() or firstsortedvalue()
>> the first row that matches...
"First"' in terms of what? Load order, date order or some other order?
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
any ideas ?