Icon

kn_​example_​r_​readr_​locale_​encoding

use R library (readr) to read CSV file into KNIME with UTF-16LE encoding

use R library (readr) to read CSV file into KNIME with UTF-16LE encoding
locale = locale(encoding = "UTF-16LE")

use R library (readr) to read CSV file into KNIME with UTF-16LE encodinglocale = locale(encoding = "UTF-16LE") library(readr)file_location <- knime.flow.in[["v_path_csv_file"]]# enter the correct delimiter like , comma ; semicolon, | pipeknime.out <- as.data.frame(readr::read_delim(file_location, delim=";", locale = locale(encoding = "UTF-16LE") , col_names = TRUE))library(arrow)library(foreign)# export file as parquetvar_loc_parquet <- paste0(knime.flow.in[["var_path_data"]], "test_file.parquet")write_parquet(x=knime.out, sink=var_loc_parquet, compression = "gzip") v_path_csv_filedummy dataread CSV filev_path*test_file.csvUTF-16LEhinditrad_chinsimpl_chinlaomalaybengaltest_file.csvUTF-16LEjpndata/test_file.tabledata/test_file.tabledata/test_file.parquet collect meta data Java EditVariable (simple) Data Generator R Source (Table) String to Path(Variable) CSV Writer ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column CSV Reader ConstantValue Column Table Writer Table Reader Parquet Reader use R library (readr) to read CSV file into KNIME with UTF-16LE encodinglocale = locale(encoding = "UTF-16LE") library(readr)file_location <- knime.flow.in[["v_path_csv_file"]]# enter the correct delimiter like , comma ; semicolon, | pipeknime.out <- as.data.frame(readr::read_delim(file_location, delim=";", locale = locale(encoding = "UTF-16LE") , col_names = TRUE))library(arrow)library(foreign)# export file as parquetvar_loc_parquet <- paste0(knime.flow.in[["var_path_data"]], "test_file.parquet")write_parquet(x=knime.out, sink=var_loc_parquet, compression = "gzip") v_path_csv_filedummy dataread CSV filev_path*test_file.csvUTF-16LEhinditrad_chinsimpl_chinlaomalaybengaltest_file.csvUTF-16LEjpndata/test_file.tabledata/test_file.tabledata/test_file.parquet collect meta data Java EditVariable (simple) Data Generator R Source (Table) String to Path(Variable) CSV Writer ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column CSV Reader ConstantValue Column Table Writer Table Reader Parquet 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: m_lauber
Created at: 2019-12-17
On NodePit since: 2021-09-22
Last update: 2024-04-26
Created with KNIME version: v4.4.1
Tags: parquetarrowimportknimereadgziprlibrarycsvreadr

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

Try NodePit Runner!