Issue filtering column names
Hey! I’m trying to use a CSV input table to filter columns from my input and I’m having issues with the column filtering.
The workflow:
So we’re taking data in at ‘Input Statistics’, renaming some columns. Then we want to filter our columns down to the list of columns from ‘Data Model Template’.
I cannot seem to be able to get the filtering to work
Here’s a screenshot of the ‘Variables connection’ of ‘Table Row to Variable’
And here’s a screenshot of the ‘Filter Excess Columns’ Flow Variables dialog:
And finally a screenshot of the output from ‘Filter Excess Columns’:
Columns like Fuel Surcharge, Mobility Package Surcharge, Marpol Surcharge and Maut are not a part of the Data Model Template and thus should be filtered out.
I tried to mimic the workflow from Column filter flow variable – KNIME Community Hub
But the filtering just does not seem to work. What could be the issue?