I have some 100 excel files at once in a folder and I need to get the column values (from row 6) to be checked with its header (from row 2 to 4) where the header contains whether that column needs a value mandatorily or not, it is string or decimal or integer or date or it meets the required length given in concatenation with the data type. All this to be done dynamically in KNIME. Can someone suggest workflow.
@AvnImpln you have th we option of table reference. So you might provide a table with the mandatory fields and reference that
And then check for the data types
You could further check for completely empty columns.
Another question would be if all your mandatory columns have to have entries in each row. You could check for a percentage of missings (by total count) and only keep the ones that are 100% complete.
Concerning the import your colleague got one answer for that in this thread:
3 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.