Below is a script that first generates your above data table, using a script, and then selects the rows where the column called "sum col" has the value of "1". Which is what you requested. However, I also added in the statement that would take those selected rows, and create a new data table, where you could do further processing:
Names Default To Here( 1 );
// Create the sample table you listed in your reply
dt = New Table( "Sample Table",
Add Rows( 10 ),
New Column( "X",
Numeric,
"Continuous",
Format( "Best", 12 ),
Set Property( "Units", "mm" ),
Set Values( [-142, -141, -140, -139, -138, -137, -91, -90, -89, -88] )
),
New Column( "Y",
Numeric,
"Continuous",
Format( "Best", 12 ),
Set Property( "Units", "mm" ),
Set Values( [-145, -145, -145, -145, -145, -145, 99, 99, 99, 99] )
),
New Column( "Z",
Numeric,
"Continuous",
Format( "Best", 12 ),
Set Property( "Units", "mm" ),
Set Values( [0, 0, 0, 3, 5, 8, 6, 3, 9, 2] )
),
New Column( "Col 01",
Numeric,
"Continuous",
Format( "Best", 12 ),
Set Values( [0, 0, 0, 0, 0, 0, 0, 0, 0, 0] )
),
New Column( "Col 02",
Numeric,
"Continuous",
Format( "Best", 12 ),
Set Values( [0, 0, 0, 0, 0, 0, 1, 1, 1, 1] )
),
New Column( "Sum Col", Numeric, "Continuous", Format( "Best", 12 ), Formula( Sum( :Col 01, :Col 02 ) ) ),
Set Row States( [1, 0, 0, 0, 0, 0, 0, 0, 0, 0] )
);
// This wait function allows for the table to be completed before the next statements
// are processed
wait(.1);
// Now select the rows where the column called Sum Col have the value of 1
dt << select where(:Sum Col == 1);
// Next create a new table from the selected rows
dtNew = dt << subset(Output Table Name("New Table"), selected columns(0), selected rows(1));
Jim