Icon

kn_​forum_​49352_​collect_​files_​paths_​subfolders

KNIME forum question (49352) - loop thru file steered by a meta file and extract certain rows

KNIME forum question (49352) - loop thru file steered by a meta file and extract certain rows


Example not consitant - error catched KNIME forum question (49352) - loop thru file steered by a meta file and extract certain rows Create path variableshttps://forum.knime.com/t/write-multiple-csv-file-to-a-loop/44989/2?u=mlauber71 Error_protocol.xlsxcontext.workflow.parent-pathpath.separator.systemcontext.workflow.data-pathdata-pathbase_folder_pathfile_name_pathOne iteration per File and Folderimport file fromlocal sub-folder(.*)(_row_)(.*)extract the Rowthe file and folder just oncein one linenew_row_namechoose variables to keep from the"Error_protocol.xlsx" fileerror_report_file_nameerror_report_foldererror_report_file_pathwriteerror_report_LOOP ENDcontinue Excel Reader Extract ContextProperties Column Expressions Variable toTable Row Column Expressions Java Snippet(simple) String to Path Table Rowto Variable Create File/FolderVariables Create File/FolderVariables Group Loop Start Excel Reader Regex Split GroupBy Table Rowto Variable Java Snippet(simple) Joiner Java EditVariable (simple) Create File/FolderVariables Create File/FolderVariables Excel Writer Variable Loop End Try (VariablePorts) Catch Errors(Var Ports) Merge Variables Merge Variables Example not consitant - error catched KNIME forum question (49352) - loop thru file steered by a meta file and extract certain rows Create path variableshttps://forum.knime.com/t/write-multiple-csv-file-to-a-loop/44989/2?u=mlauber71 Error_protocol.xlsxcontext.workflow.parent-pathpath.separator.systemcontext.workflow.data-pathdata-pathbase_folder_pathfile_name_pathOne iteration per File and Folderimport file fromlocal sub-folder(.*)(_row_)(.*)extract the Rowthe file and folder just oncein one linenew_row_namechoose variables to keep from the"Error_protocol.xlsx" fileerror_report_file_nameerror_report_foldererror_report_file_pathwriteerror_report_LOOP ENDcontinueExcel Reader Extract ContextProperties Column Expressions Variable toTable Row Column Expressions Java Snippet(simple) String to Path Table Rowto Variable Create File/FolderVariables Create File/FolderVariables Group Loop Start Excel Reader Regex Split GroupBy Table Rowto Variable Java Snippet(simple) Joiner Java EditVariable (simple) Create File/FolderVariables Create File/FolderVariables Excel Writer Variable Loop End Try (VariablePorts) Catch Errors(Var Ports) Merge Variables Merge Variables

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: 2022-11-28
On NodePit since: 2022-11-28
Last update: 2024-04-28
Created with KNIME version: v4.6.4
Tags: importlooppathvariables

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

Try NodePit Runner!