652919_it-IT

liliconcom

Come funziona la formula pass/fail?

Sto riscontrando un problema in cui le formule restituiscono valori nulli.
La tabella grezza è costituita dai dati grezzi e c'è una tabella delle specifiche, che viene utilizzata per determinare se i dati grezzi passano o falliscono in base alla tabella delle specifiche. Ho scritto un JSL, per favore aiutami a vedere qual è il problema, grazie.

Names Default To Here( 1 );
//raw data
dt = Data Table( "raw data001" );

dt1 = dt << subset( all rows, all columns );

//spec table

dtbz = Data Table( "Spec" );
LSL = dtbz[0, 4];
USL = dtbz[0, 5];
dtbz << New Column( "combine", formula( :Project || :Item ) );

// Create separate judgment columns for the columns to be judged
items = Design( dtbz:Item << get values(), <<LEVELS> 0,
     dtbz:USL[Loc( dtbz:combine << get as matrix(), "A" || it )[1]] <= Column( dt1, items[i] ) <= dtbz:USL[
     Loc( dtbz:combine << get as matrix(), "A" || it )[1]],  
     
    :Project == "B" & N Items( Loc( dtbz:combine << get as matrix(), "B" || it ) ) > 0,
     dtbz:USL[Loc( dtbz:combine << get as matrix(), "B" || it )[1]] <= Column( dt1, items[i] ) <= dtbz:USL[
     Loc( dtbz:combine << get as matrix(), "B" || it )[1]],  
     
    :Project == "C" & N Items( Loc( dtbz:combine << get as matrix(), "C" || it ) ) > 0,
     dtbz:USL[Loc( dtbz:combine << get as matrix(), "C" || it )[1]] <= Column( dt1, items[i] ) <= dtbz:USL[
     Loc( dtbz:combine << get as matrix(), "C" || it )[1]],  
     
    :Project == "D" & N Items( Loc( dtbz:combine << get as matrix(), "D" || it ) ) > 0,
     dtbz:USL[Loc( dtbz:combine << get as matrix(), "D" || it )[1]] <= Column( dt1, items[i] ) <= dtbz:USL[
     Loc( dtbz:combine << get as matrix(), "D" || it )[1]],  
     
      
      
   )
  )
 )
);</LEVELS>

Mac OS