I 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")
Question
Transformer to search for a value/regexp in any column
+16- Contributor
- 33 replies
+12- Contributor
- 105 replies
+58- Evangelist
- 932 replies
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?
+60- 2937 replies
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.