Skip to main content
Question

FIltering out large number of Attribute values

  • October 17, 2017
  • 5 replies
  • 213 views

fmeuser_gc
Contributor
Forum|alt.badge.img+9

Need to filter out the large list of Attribute values(Around random 10000 values) to be processed. Currently it is tedious using 'AttributeFilter' transformer as it needs all 10000 output ports to be connected to next transformer for further processing.

There should be other transformers for sure which I don't remember any. Please help.

-Thanks

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.

5 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • October 17, 2017

Hi @fmeuser_gc,

You can try to use the transformer AttributeRangeFilter.

The option Generate enable you set values Minimum and Maximum and the number of Ranges.

Thanks,

Danilo


fmeuser_gc
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • 81 replies
  • October 17, 2017

Hi @fmeuser_gc,

You can try to use the transformer AttributeRangeFilter.

The option Generate enable you set values Minimum and Maximum and the number of Ranges.

Thanks,

Danilo

This transformer might need all ranges. But I can't use range as all the values are random

 

.

 

 


erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • October 17, 2017

I would list the values in an external source (database table, csv file, Excel file) and use the FeatureMerger to check if the values are available in the external source.

The database table would be my preference.

That allows adding values to the source without having to change the workspace.


fmeuser_gc
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • 81 replies
  • October 17, 2017

I would list the values in an external source (database table, csv file, Excel file) and use the FeatureMerger to check if the values are available in the external source.

The database table would be my preference.

That allows adding values to the source without having to change the workspace.

@erik_jan, this worked and is the best reply. You saved my time. Thanks.

joy
Enthusiast
Forum|alt.badge.img+15
  • Enthusiast
  • 88 replies
  • February 14, 2024

In addition to what @erik_jan said, instead of featuremerger, you could also use the databasejoiner.
Then you don't need another reader.