675113_en-US

liliconcom

Delete values

Hello everyone,

 

I have a database with duplicate values for some columns. The objective is to remove values from a column by assigning the value “.when the previously mentioned columns have duplicate values.

 

Here is an overview of the database:

 

 

 

For example, on this extract: when there are duplicate cells (task column, batch and op) it would be necessary to be able to assign the value “.(this therefore amounts to deleting the values) in the % Prd, % Proc, % Prd (6months), % Proc (6months) columns.

 

I started with the following script:

 

Names Default To Here( 1 );

dt = current data table();

// Sélectionner les lignes dupliquées
a = dt << Select Duplicate Rows( Match( :lot, :tache, :op ) );

Column(dt, 11)[a] =.;
Column(dt, 12)[a] =.;
Column(dt, 13)[a] =.;
Column(dt, 14)[a] =.;

Thanks for your help !

Data Access