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?

  • May 11, 2020
  • 4 replies
  • 16 views

Forum|alt.badge.img+2

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.

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

Forum|alt.badge.img+2
  • 194 replies
  • May 11, 2020

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+2
  • Author
  • 11 replies
  • May 11, 2020

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
Celebrity
  • 7843 replies
  • Best Answer
  • May 11, 2020

Here is another way.


Forum|alt.badge.img+2
  • Author
  • 11 replies
  • May 11, 2020

Here is another way.

This also works. Thank you.