Identifying the First value of an attribute

Could some one please let me know
1. How can we identify the first value of an attribute ?
2. How do we identify the first value of an attribute based on grouping ?
3. How do we create a new attribute with first value assigned based on grouping of other attributes ?

Find more posts tagged with

AI Studio

Accepted answers

All comments

lionelderkrikor

Hi @swamysantoshkumar,

To identify the first value of an attribute, you can use the Filter Example Range operator and set
first example = 1
last example = 1

For you questions 2. and 3. I have difficulties to understand :
Can you provide :
- an example of what you have and
- an example of what you want to obtain

Regards,

Lionel

swamysantoshkumar

Thanks for the response @L ionelderkrikor

Below is the example in which I would need attributes 3 & 4 to be created from Attributes 1 & 2

1. How do we identify the first value of an attribute and assign it as new attribute for all examples

2. How do we identify the first value of an attribute specific to a group of examples

3. How do we create the new attribute by assigning the first value identified in step 2

I would like to generate Attribute 3 and 4 as depicted in the below table

Ex:

Attribute 1 Attribute 2 Attribute 3 Attribute 4

A 10 10 10

A 20 10 10

A 25 10 10

A 40 10 10

B 30 10 30

B 40 10 30

C 50 10 50

C 60 10 50

lionelderkrikor

@swamysantoshkumar,

In attached file, a process to generate your att_3 based on att_1 and att_2.
For your second request (generate att_4) I need a little time of reflexion ...

Stay tuned !

Regards,

Lionel

attribute_first_value.rmp

lionelderkrikor

@swamysantoshkumar

.....and here, in attached file, the final process (including generation of attribute 4) which use Group into Collection / Loop Collection operators

Does this process answer to your need ?

Regards,

Lionel

attribute_first_value_2.rmp

swamysantoshkumar

@lionelderkrikor

Thank you so much ! Yes it really helps. This is what I was looking for.

Thanks again..
Santosh !

lionelderkrikor

You're welcome, @swamysantoshkumar.

Good luck for your study !

Regards,

Lionel