Skip to main content
  • EN

Hi !

I have an xls file with 2 columns. One contains a code and the other contains numerics values.

I would like to create an attribute that group my data when there are a break on the values and group by code. For example :

 

code value

a 1 => group 1

a 2 => group 1

a 3 => group 1

a 10 => group 2

a 11 => group 2

b 1 => group 3

b 2 => group 3

 

I saw "AttributeRangeMapper" but I have to indicate the bounds. In my case I would like that the bounds are create automatically because my datas change every time.

My values can be integer or decimal.

 

Thanks !

 

Use the 'Adjacent Feature Attributes' option of the AttributeManager. When 'Code' does not change, and 'Value' increases by 1, use the current group number. In all other cases increase the group number by 1.

Grouping

Great!

I didn't know this option.

Thank you! It works very well!

That's what I like most about this community: is a great place to learn something new about FME. Every day!

Reply


Community Stats

30,168
Posts
114,527
Replies
37,825
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.