Skip to main content
Question

Transformer to search for a value/regexp in any column


hlouie
Contributor
Forum|alt.badge.img+16

find in any columnI know StringSearch can look at that one selected column but I'm looking for a transformer that will search any column for a value? (similar way Visual Preview can find ??? in "any column")

3 replies

muzhnasto
Contributor
Forum|alt.badge.img+12
  • Contributor
  • July 6, 2022

geomancer
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • July 6, 2022

Can you combine all attributes in a new attribute (using StringConcatenator or AttributeCreator or AttributeManager), placing a separator character between the different attribute values, and search the resulting attribute?

Combine_Attributes


nielsgerrits
VIP
Forum|alt.badge.img+55

If you also need the corresponding column name and / or you want to make it dynamic you can use the AttributeExploder to create a feature for each attribute and search in _attr_value.

 

Edit: this is the way the GlobalStringSearcher from the hub works.


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