Icon

kn_​forum_​26453_​import_​csv_​messy_​file

Import messy CSV file

Import messy CSV file

library(readr)file_location <- knime.flow.in[["v_path_csv_file"]]# enter the correct delimiter like , comma ; semicolon, | pipeknime.out <- as.data.frame(read_delim(file_location, delim=",",col_names = TRUE)) Import messy CSV file solution by https://forum.knime.com/u/ScottF check line21v_path_csv_fileread CSV filecheck line21locate and create/data/ folderwith absolute pathsresult.table File Reader(deprecated) Java EditVariable (simple) R Source (Table) File Reader(deprecated) Collect LocalMetadata Table Writer library(readr)file_location <- knime.flow.in[["v_path_csv_file"]]# enter the correct delimiter like , comma ; semicolon, | pipeknime.out <- as.data.frame(read_delim(file_location, delim=",",col_names = TRUE)) Import messy CSV file solution by https://forum.knime.com/u/ScottF check line21v_path_csv_fileread CSV filecheck line21locate and create/data/ folderwith absolute pathsresult.table File Reader(deprecated) Java EditVariable (simple) R Source (Table) File Reader(deprecated) Collect LocalMetadata Table Writer

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: m_lauber
Created at: 2020-09-01
On NodePit since: 2020-09-02
Last update: 2024-04-27
Created with KNIME version: v4.7.7
Tags: csvreadrrimportmessy

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

Try NodePit Runner!