Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA\Semiconductor Capability.jmp" ); lookup = dt << Summary( Group( :lot_id, :wafer ), Mean( :NPN1 ), Median( :NPN1 ), Freq( "None" ), Weight( "None" ), statistics column name format( "column stat" ), Link to original data table ( 0 ) ); // Now get info into the dt data table from the lookup table // without doing a join dt << New Column( "Mean" ); dt << New Column( "Median" ); For( i = 1, i <= N Rows( dt ), i++, lookupRow = (lookup << get rows where( lookup:lot_id == dt:lot_id[i] & lookup:wafer == dt:wafer[i] ))[1]; dt:Mean[i] = lookup:NPN1 Mean[lookupRow]; dt:Median[i] = lookup:NPN1 Median[lookupRow]; );