i have some data and i want to check the data type of the each column and skip the invalid data types
eg: i have name column with the data( xyz, abc, 123)
here i want only xyz and abc as those are string and add based the data type i need to input this data to another table.
thank you Aswin. i tried the second one but the issue here if you 2 rules ( col1,col2) then it is not giving correct output
it is working only one rule(col1) i mean one column. how do we check for the all the columns?
I am novice to Knime and i may be asking basic qns. here is my another requirement
im expecting only 10 columns in my input files. if file has more than 10 columns then i need to filter the additional columns to new table and use it only 10 columns.
i can filter it manually but how do i automate it ? when ever new file comes it has to pick only 10 columns and run the flow.
Hi @mlauber71 …Thanks for the effort …If I use a column filter node based on type selection …I am not able to handle Date fields ( datatype for Date fields in my Dataset is Date cell and this type selection will filter values of Date & Time) …Are you aware of any conversion that converts Datecell to Date and Time format in type selection option of Column filter…All other Datatypes can be easily handled as per type selection suggested by you.