344553_en-US

liliconcom

is there a script we could use to remove repetitions/Duplicate data?

 

AnalyticsData TableDOEOtherScriptingRe: is there a script we could use to remove repetitions/Duplicate data?

If you are working interactively then you don't need a script:

1. Select the column(s) you are interested in (in your case 'Batch')
2. Use Rows > Row Selection > Select Duplicate rows to select duplicate rows
3. Use Rows > Delete Rows to remove them.

If this is part of a larger script then you can use the intuitively named functions. Take a look at the scripting index for more info on each:

names default to here(1);
dt = Open( "$Sample_data/Big class.jmp" );

dt << Select Duplicate Rows( match(:age));
dt << Delete Rows;