652919_zh-CN

liliconcom

通过/失败公式如何运作？

我遇到一个问题，公式返回空值。
raw表就是原始数据，有一个规格表，用于根据规格表来判断原始数据是否通过。 我写了一个JSL，请帮我看看问题出在哪里，谢谢。

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>

苹果系统