Skip to main content
Solved

check every cell if it is located between two attributes or not

  • February 26, 2020
  • 2 replies
  • 16 views
gogopotter90
Contributor
Forum|alt.badge.img+14

Hi Guys,

i have excel file ,i want to make comparison

as

if sum 1 < base A < sum 2

 

if yes ,

so as give me the output

i want to check for every cell in base A is the value between sum1 and sum 2 in the each row or not .as example check the first cell of base A (65452 ) is between sum 1 and sum 2 at first row or not then continue to check 65452,first cell of base A with the second row of sum 1 and sum 2 or not .

 

i want to check for each cell in base A ,if this value between sum1 and sum 2 for each row .

after finish checking 65452 so start with 65438 and so on so it will check for each cell with 10 rows

 

i want to do the same also for Base B ,if the value between sum 1 and sum 2 and if yes gives me output and continue check for this cell till the end

 

till i finish with all field cells in base A and base B

 

Thanks in advance

 

FME version 2018

 

Best answer by markatsafe

@gogopotter90 Thanks for including a small sample dataset.

I think you need to do a full outer join for each "base A' to every row in the table and the same for "base B". You can simulate this using FeatureJoiner by creating a temporary key attribute, i.e. _key = 1. Then you can apply your test. The workspace might look something like;

Workspace attached (2019.2): fullouterjoin.fmwt

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

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • Best Answer
  • February 26, 2020

@gogopotter90 Thanks for including a small sample dataset.

I think you need to do a full outer join for each "base A' to every row in the table and the same for "base B". You can simulate this using FeatureJoiner by creating a temporary key attribute, i.e. _key = 1. Then you can apply your test. The workspace might look something like;

Workspace attached (2019.2): fullouterjoin.fmwt

gogopotter90
Contributor
Forum|alt.badge.img+14
  • gogopotter90Contributor
  • Author
  • Contributor
  • 239 replies
  • February 26, 2020

@gogopotter90 Thanks for including a small sample dataset.

I think you need to do a full outer join for each "base A' to every row in the table and the same for "base B". You can simulate this using FeatureJoiner by creating a temporary key attribute, i.e. _key = 1. Then you can apply your test. The workspace might look something like;

Workspace attached (2019.2): fullouterjoin.fmwt

thanks alot i modified it and it is working great

Community Stats

32,076
Posts
121,798
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.