Skip to main content
Question

FIltering out large number of Attribute values

  • October 17, 2017
  • 5 replies
  • 178 views

fmeuser_gc
Contributor
Forum|alt.badge.img+8

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

5 replies

danilo_fme
Evangelist
Forum|alt.badge.img+41
  • Evangelist
  • 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+8
  • Author
  • Contributor
  • October 17, 2017
danilo_fme wrote:

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+17
  • Contributor
  • 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+8
  • Author
  • Contributor
  • October 17, 2017
erik_jan wrote:

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
Supporter
Forum|alt.badge.img+14
  • Supporter
  • 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.


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