Icon

CSV - List and Load several files and check integrity

<p>List several CSV files and check them for integrity</p>

URL: KNIME Comunity https://community.knime.com/c/ask-the-community/concatenate-multiple-csv-files#comment_wrapper_112760428
URL: Medium: KNIME — Cases, Switches and Catching Errors https://medium.com/low-code-for-advanced-data-science/knime-cases-switches-and-catching-errors-5ab748cbeaa3

Example Data Reader
it check fails, an empty row is providedto continue
Row Filter
collect the resultsfrom the CSV thatmatch the example
Loop End
Path
Constant Value Column Appender
/data/*.csvlist files in a folder
List Files/Folders
Path to URI
loop overPathvariables
Table Row to Variable Loop Start
GroupBy
Path_location
Path to String (Variable)
Path to String
Try (Variable Ports)
Catch Errors (Data Ports)
CSV Reader
the CSV files that did not match the example
Reference Row Filter
if the structure does not matchthe top port will fail
Reference Table Validator
create theexample CSV filesnumber 4 is different
Component

Nodes

Extensions

Links