Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
try this:
example attached also.
[ResultsTemp]:
LOAD wo,
quantity
resident WorkOrder;
left join
LOAD wo,
op_no,
op_def
Resident Routing;
right join
LOAD wo,
max(op_no) as op_no,
max(date) as date
Resident MalzDefteri
group by wo;
Results:
load wo,
quantity,
if(op_def='yy',date,null()) as date
Resident [ResultsTemp];
Dear Kadir,
Could explain what you need or supply more details what is you issue?
Regards.
Ricardo , thank you for your interest.
I have three tables. two tables together 'vlookup' I can connect with. but my need to get the greatest value in the other table record by the conditions in the two tables.
example :
work order take the value 1 table with table century 'op_def' worth of space 'century' from the record 'malz defteri' table to call the maximum date information. it 'load script' or 'calculated expression' with no harm being.
Sorry for bad english. I'm using translate
thank you so much