- Type: TableData sourceData source containing a column to be mateched against the required Regex column.
- Type: TableLookup TableLookup table containing regex patterns to be matched against
Iterates the Lookup table on the lower port and attempts a regex match using a regex pattern on the lookup table with a column on the Source data table on the Upper input port. The resultant table is the original data source enriched with with the lookup table where matches are found If multiple lookup matches are found, all are returned. This loop component would be better for large data sets as it iterates the lookup table once and uses a filter on the data source rather than a straight cross join. This should make it less memory intensive than a standard cross join solution. It also does not require the loading of data into an H2 database and so makes it compatible with tables that contain data elements unsupported by H2, and also does not require the data table to be loaded into H2 tables. @takbb Brian Bates 13 November 2022
- Type: TableEnriched Data SourceThe data source enriched with selected columns of matching lookup table rows. It also contains the rowid of the original data source with which the match was made, in case multiple matches occured for a given data source item
Used extensions & nodes
Created with KNIME Analytics Platform version 4.6.3
By using or downloading the component, you agree to our terms and conditions.