Skip to main content
Solved

Math operations between values in the same column


delgadojeaneth
Contributor
Forum|alt.badge.img+1

Dear all,

I hope you can help to solve this question. I need to calculate Length ranges and I have as data class and Length. Can you help me please?

Class Length Lenght-ranges

A-1 100 100

A-2 250 (100-250) = 50

A-3 300 (250-300) =50

B-1 10 10

B-2 30 20

B-3 80 50

C-1 40 40

C-2 100 60

C-3 200 100

Best answer by oscard

I think now I do understand what you need.

 

You need to use AttributeManager enabling adjacent features:

 

 

And then create the Range attribute with a conditional value:

 

xlsxr2none.fmw

View original
Did this help you find an answer to your question?

4 replies

oscard
Influencer
Forum|alt.badge.img+21
  • Influencer
  • April 8, 2019

First, I would use a StringReplacer to remove the spaces around the character "=". The goal is getting:

A-1 100 100

A-2 250 (100-250)=50

A-3 300 (250-300)=50

B-1 10 10

B-2 30 20

B-3 80 50

C-1 40 40

C-2 100 60

C-3 200 100

Then I would use AttributeSplitter using a blank space " " as the character used for splitting. That way you will get a list with 3 elements in every feature:

_list{0} --> Class

_list{1} --> Length

_list{2} --> Range


delgadojeaneth
Contributor
Forum|alt.badge.img+1

Sorry, I was not clear. Length-ranges (column in yellow) it is what I want to get. I have only class and Length.

sampledata.xlsx

 

 


oscard
Influencer
Forum|alt.badge.img+21
  • Influencer
  • Best Answer
  • April 8, 2019

I think now I do understand what you need.

 

You need to use AttributeManager enabling adjacent features:

 

 

And then create the Range attribute with a conditional value:

 

xlsxr2none.fmw


delgadojeaneth
Contributor
Forum|alt.badge.img+1
oscard wrote:

I think now I do understand what you need.

 

You need to use AttributeManager enabling adjacent features:

 

 

And then create the Range attribute with a conditional value:

 

xlsxr2none.fmw

Thanks, it worked.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings