Skip to main content
Question

Creating unique values based on ranges

  • December 2, 2019
  • 2 replies
  • 9 views

Hi all,

If have an issue creating a unique column for a range of points. The points are separated (based on calculations) in ranges that run from 3 to 2, all the point within this range have 1 values (for example 3,1,1,1,2). I would like to generate a new column containing for each range an unique id. See my example columns down below, showing the preferred result:

UUIDRangesPreferred ResultA31A

 

11A

 

21A

 

-

 

A

 

32A

 

12A

 

22B33B

 

13B

 

13B

 

23C34C14

 

Is there a way to calculate this final column?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • December 2, 2019

So the features are in order and the first feature always has a range value of 3?

You can use adjacent attribute mapping to increment a group number everytime 3 is encountered

Probably easiest to deal with the range with value '-' afterwards


gazza
Contributor
Forum|alt.badge.img+6
  • Contributor
  • 132 replies
  • December 2, 2019

A couple of ideas, you could use a StatisticsCalculator grouping by Range and look at the _count value coming out of the Cumulative port.

Or use a Counter where the counter name is dynamically generated using range, such as counter_@Value(Range)