Skip to main content
Solved

How to filter based on several attributes instead of one attribute?

  • April 13, 2022
  • 2 replies
  • 638 views

joy
Enthusiast
Forum|alt.badge.img+15
  • Enthusiast
  • 88 replies

I am currently importing a dgn file into FME and I am trying to filter the cells based on the following attributes igds_cell_name and igds_cell_insertion_x/y/z . With the AttributeFilter one is able to filter based on one attribute, however I would thus like to filter based on the above mentioned 4 attributes , so I can aggregate afterwards the cells that have the same value for the above mentioned attributes. Does anyone know how I might be able to achieve that. I wouldn't want to make use of a TestFilter, since with a TestFilter you have to write manually out all the possible values with AND clauses. That would be too much work for me.

Best answer by dustin

I would use a StringConcatenator to combine the values from the 4 attributes into one attribute value. Then aggregate based on the new concatenated value.

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

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • 627 replies
  • Best Answer
  • April 13, 2022

I would use a StringConcatenator to combine the values from the 4 attributes into one attribute value. Then aggregate based on the new concatenated value.


joy
Enthusiast
Forum|alt.badge.img+15
  • Author
  • Enthusiast
  • 88 replies
  • April 13, 2022

@dustin​ This works like a gem, thanks for this clever idea!