CSV Reader (error-safe)

Encapsulated CSV Reader with error checking so that it doesn't fail if no file is specified, or the specified file does not exist.

In the event of an error, an empty table is returned with the specified default column names.

If you require different CSV file settings, disconnect the component, open it and edit the CSV Reader than share it locally under a new name


@takbb Brian Bates 26 November 2022

Options

Location type

Enter the type of location, to indicate if this represents a folder in the current workflow or an Absolute path

Default Columns (Delimit by | )

Specify the default columns to use if file does not exist. Delimit columns with pipe | character

Location/File to open

A string representing the folder (or a file) to be opened on execution.%%00010%%00010Leave blank to open the workflow folder

Nodes

• String Configuration7 ×
• Rule Engine Variable4 ×
• Component Input3 ×
• Component Output3 ×
• Boolean Configuration2 ×
• Cell Splitter2 ×
• Java Edit Variable2 ×
• Single Selection Configuration2 ×
• Variable to Table Row2 ×
• CASE Switch Variable (End)1 ×
• CASE Switch Variable (Start)1 ×
• CSV Reader1 ×
• Catch Errors (Data Ports)1 ×
• Column Aggregator1 ×
• Column Auto Type Cast1 ×
• Column Filter1 ×
• Create Collection Column1 ×
• Create File/Folder Variables1 ×
• Extract Context Properties1 ×
• Insert Column Header1 ×
• Java Edit Variable (simple)1 ×
• Merge Variables1 ×
• Row Filter1 ×
• RowID1 ×
• String Manipulation (Multi Column)1 ×
• String to Path (Variable)1 ×
• Table Row to Variable1 ×
• Transpose1 ×
• Try (Variable Ports)1 ×
• Ungroup1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available