Save File Locally

This node saves a copy of the text files held in a table column to filepaths held in a second column.
A rudimentary attempt is made to validate the filepaths - which must be complete paths, e.g. C:\Temp\myfile.txt If the full folder path does not exist, an attempt is made to create it.
The returned column will contain a missing value if either of the input columns is a missing value, 'true' if the file was successfully written, and 'false' if it was not written (i.e. because overwrite was set to off, and the file existed, or because the directory could not be created or was not a valid path)
This node can be used to create txt files, or save pdb, mol, mol2 files etc. by providing an appropriate filepath and extension.

Options

Select a column name containing the file cells

The column containing the content to be written to the file

Enter name of column for file paths

The column containing the full path to the output files

Save all files in parent folder

If checked, then the file path folder is assumed to contain sub-paths, or simply filenames, and will be relative to the indicated parent folder

Parent Directory

The optional parent folder to save files in

Overwrite files

If checked, existing files are overwritten without warning

Enter name of column for save successful flag

The name of a column for the outcome to be put in

Input Ports

The input table containing a column with text and a column with filepaths

Output Ports

The input table with a boolean column indicating the outcome of local save added

Best Friends (Incoming)

• String Manipulation (12 %) Streamable
• RowID (10 %) Streamable
• Java Snippet (6 %) Streamable
• Column Filter (6 %) Streamable
• List Files (4 %) 
• Concatenate (4 %) Streamable
• Constant Value Column (4 %) Streamable
• Cross Joiner (4 %) Streamable
• Call Remote Workflow (Row Based) (2 %) 
• Load text-based files (2 %) Streamable
• String to URI (2 %) 
• Variable to Table Column (2 %) Streamable
• Table Row to Variable (2 %) 
• Table Row To Variable Loop Start (2 %) 
• Database Reader (legacy) (2 %) 
• Loop End (2 %) 
• Column Aggregator (2 %) Streamable
• Row Filter (2 %) Streamable
• Joiner (2 %) 
• Column Rename (2 %) Streamable
• Column Splitter (2 %) Streamable
• String Replacer (2 %) Streamable
• Cache (2 %) 
• OpenBabel (2 %) 
• Excel Reader (XLS) (2 %) StreamableDeprecated
• Excel Reader (XLS) (2 %) Streamable
• Document Data Extractor (2 %) Deprecated
• Document Data Extractor (2 %) 
• Strings To Document (2 %) StreamableDeprecated
• File Upload (2 %) 
• Python Script (2⇒2) (2 %) 
• HTTP Result Data Extractor (2 %) 
• HTML Parser (2 %) 
• Show all 33 recommendations

Best Friends (Outgoing)

• Loop End (25 %) 
• Variable to Table Column (13 %) Streamable
• Table Column to Variable (13 %) 
• CSV Writer (13 %) Streamable
• Variable Condition Loop End (13 %) 
• GroupBy (13 %) 
• External Tool (13 %) 
• Show all 7 recommendations

Installation

To use this node in KNIME, install Vernalis KNIME Nodes from the following update site:

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.