loadscript in condition

[#1]

[Anonymous]

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];

[Ricardo_Gerhard]

Dear Kadir,

   Could explain what you need or supply more details what is you issue?

Regards.

[#4]

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