Solved

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

  • 13 April 2022
  • 2 replies
  • 66 views

Badge +13
  • Contributor
  • 56 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.

icon

Best answer by dustin 13 April 2022, 14:42

View original

2 replies

Userlevel 3
Badge +26

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.

Badge +13

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

 

Reply