🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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

User: "LeMarc"
New Altair Community Member
Updated by Jocelyn
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

Sort by:
1 - 4 of 41
    Hi,
    can you give an example for this id?
    Best,
    Martin
    User: "LeMarc"
    New Altair Community Member
    OP
    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



    User: "MartinLiebig"
    Altair Employee
    Accepted Answer
    Hi,
    The remove duplicates operator should do the trick.

    ~Martin
    User: "LeMarc"
    New Altair Community Member
    OP
    Thanks @mschmitz!
    Totally forgot about that option/operator.