Skip to main content
Solved

Is there a way to Sort by Field A but only if the first row in Field B is missing?


Forum|alt.badge.img+1

I have a sorter, but I do not want it to sort if the first row in Field B has a value. I am guessing this will need a combination of transformers.

Best answer by takashi

Here is another way.

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

4 replies

Forum|alt.badge.img+2

There are a few ways to do that. A solely FME way to do it is below. The tester output will be passed if it's not null and failed if it's null.

You could also use a python script or various other ways with different transformers.

 


Forum|alt.badge.img+1
  • Author
  • May 11, 2020
jlbaker2779 wrote:

There are a few ways to do that. A solely FME way to do it is below. The tester output will be passed if it's not null and failed if it's null.

You could also use a python script or various other ways with different transformers.

 

Thanks for sharing that. I was able to get it to work using a different method. I used a combination of testers, counters (local), and the statistics calculator. See attached image.


takashi
Influencer
  • Best Answer
  • May 11, 2020

Here is another way.


Forum|alt.badge.img+1
  • Author
  • May 11, 2020
takashi wrote:

Here is another way.

This also works. Thank you.


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