Skip to main content
  • EN

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")

Hi @hlouie​ maybe https://hub.safe.com/publishers/gisinnovationsb/transformers/globalstringsearcher and https://hub.safe.com/publishers/gisinnovationsb/templates/globalsearch

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

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.

Reply


Community Stats

30,167
Posts
114,520
Replies
37,824
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.