Skip to main content
Solved

Math operations between values in the same column

  • April 8, 2019
  • 4 replies
  • 21 views

delgadojeaneth
Contributor
Forum|alt.badge.img+2

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

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.

4 replies

oscard
Influencer
Forum|alt.badge.img+22
  • Influencer
  • 344 replies
  • 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+2
  • Author
  • Contributor
  • 5 replies
  • April 8, 2019

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+22
  • Influencer
  • 344 replies
  • 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+2
  • Author
  • Contributor
  • 5 replies
  • April 16, 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

Thanks, it worked.