🎉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

Generate New Attribute

User: "LeMarc"
New Altair Community Member
Updated by Jocelyn
Hello,

I want to generate an attribute [AttNew]. The values of the new attribute should be according to the following rule:
  • If ID xy only exist one time
  • --> For ID xy Take the value of the Att1 for the new Attribute [AttNew]
  • If there are several identical IDs,
  • -> take all the values of Att 1 of the identical IDs
  • --> and include them as a new attribute value for the generated attribute [2]
The reason behind that, I want to remove duplicate (or more) IDs but do not want to lose any information.
Below is the picture
(1)

To
(2)


Is there an operator which does that? Or can anyone help how to describe the function?


Thank you very much!

Find more posts tagged with