User input Column filtering

[muthuvisakanm]

Hello Team !

I am new to this knime world ! . I need to know how to filter the excel data using column name . But the column name should be the user input. Could somebody help me

If user enters john !

[rfeigel]

What’s type of input file, e.g. csv, xlsx? Does it have a column header?

[rfeigel]

Try this. It assumes the first row is the column header. It does no error trapping for misspelled or missing names.

User Input Column Filtering – rfeigel

[takbb]

@rfiegel I think something got corrupted on your link, as weirdly it shows " Sorry! This page doesn’t exist.", but this seems to work:

User Input Column Filtering – rfeigel

[rfeigel]

@takbb Thanks for the heads up. Have no idea what happened.

[rfeigel]

This revision corrects the dynamic column renaming.

User Input Column Filtering rev 1 – rfeigel

[ArjenEX]

An alternative would be a Column Filter Widget based component.

It gives a bit more flexibility and requires a lot less nodes to achieve the desired filtering.

[rfeigel]

@ArjenEX The issue is not what widget to use. All the extra nodes in my workflow are to create a column header rather than let the first row of data become the column header. If the user doesn’t care then a simpler workflow with either string or column widget will be fine.