Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

how to remove two identical ID numbers within a single attribute?

Hi,

I would like to customize an expression which states:

If id attribute consist of two identicial ID numbers, then delete one of the ID Nrs (doesnt matter which one),

otherwise do nothing)

Can anybody help how to properly formulate ?

Find more posts tagged with

AI Studio

Accepted answers

Hi,

The remove duplicates operator should do the trick.

~Martin

All comments

Hi,

can you give an example for this id?

Best,

Martin

The goal is to have an example set in which the attribute column "id" doesnt have the same id number twice.

In this case, there are two examples/rows within the example set which exist twice (id number 23 & 46). Therefore I only want to keep only one example/row of each Id number which exist more than once

Image: https://us.v-cdn.net/6030995/uploads/editor/z9/7bb7dctr7c2v.png

Hi,

The remove duplicates operator should do the trick.

~Martin

Thanks @mschmitz!

Totally forgot about that option/operator.

Quick Links