Icon

Read multiple CSVs with defined types

There has been no description set for this workflow's metadata.

Similar to before but uses my "RedfineTable Column Types" component whichattempts to define column types by using areference sample data set.The idea is to remove possibility ofvariations between executions when youmay have different data but still always wantit to be processed the same way (i,e withconsistent data types) Let the CSV reader handle reading files from afolder without requiring loop construct Transformation includedto treat all numerics asString to ensure they will loadDefine data types basedon sample dataSample reference datato supply required typesScan all files in a folderand allow for changing schemaNo need for loop CSV Reader Redefine TableColumn Types Table Creator CSV Reader Similar to before but uses my "RedfineTable Column Types" component whichattempts to define column types by using areference sample data set.The idea is to remove possibility ofvariations between executions when youmay have different data but still always wantit to be processed the same way (i,e withconsistent data types) Let the CSV reader handle reading files from afolder without requiring loop construct Transformation includedto treat all numerics asString to ensure they will loadDefine data types basedon sample dataSample reference datato supply required typesScan all files in a folderand allow for changing schemaNo need for loop CSV Reader Redefine TableColumn Types Table Creator CSV Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: brian
Created at: 2022-03-04
On NodePit since: 2022-03-04
Last update: 2024-11-21
Created with KNIME version: v4.5.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!