Icon

Merge tables and save rows to multiple excel files

Convenience componentfor creating flow variablesto file Get data from both spreadsheets Append all rows to all rows from both data sources, thenremove old Column B from "Main", and reorganise colsintocorrect order Process the rows in groupings based on column B and write to the requiredoutput file. This currently writes to the local workflow data, but alternativelyyou could create an absolute path as the String variable, then convert theString to a Path (Variable) and use that directly in Excel Writer.I have used the "Open File or Folder" component here as it convenientlyallows creation of a local data path flow variable with very little effort. I couldn't find a way of telling Excel Writer to write to a file called simply100.xlsx (for example) but put it in the workflow data folder, as I seemed tohave to give it an absolute path. All DataTrackerShip toKeep just column BMain DataExecute this nodeto "open" Workflow Data folderin ExplorerJoin all rowsto all rowsGet "Main" column B- not requiredtidy columnsLoop through datain row groups based on Column Bmake a filenamevariable based on Column B contentsWrite currentgroup of rows to therequired file nameMake filename intoa local pathRepeat forall groupsOpen the data folder to viewoutput files Open File or Folder Excel Reader Excel Reader Column Filter Open File or Folder Open File or Folder Cross Joiner Column Filter Column Resorter Group Loop Start String Manipulation(Variable) Excel Writer Open File or Folder Variable Loop End Open File or Folder Convenience componentfor creating flow variablesto file Get data from both spreadsheets Append all rows to all rows from both data sources, thenremove old Column B from "Main", and reorganise colsintocorrect order Process the rows in groupings based on column B and write to the requiredoutput file. This currently writes to the local workflow data, but alternativelyyou could create an absolute path as the String variable, then convert theString to a Path (Variable) and use that directly in Excel Writer.I have used the "Open File or Folder" component here as it convenientlyallows creation of a local data path flow variable with very little effort. I couldn't find a way of telling Excel Writer to write to a file called simply100.xlsx (for example) but put it in the workflow data folder, as I seemed tohave to give it an absolute path. All DataTrackerShip toKeep just column BMain DataExecute this nodeto "open" Workflow Data folderin ExplorerJoin all rowsto all rowsGet "Main" column B- not requiredtidy columnsLoop through datain row groups based on Column Bmake a filenamevariable based on Column B contentsWrite currentgroup of rows to therequired file nameMake filename intoa local pathRepeat forall groupsOpen the data folder to viewoutput filesOpen File or Folder Excel Reader Excel Reader Column Filter Open File or Folder Open File or Folder Cross Joiner Column Filter Column Resorter Group Loop Start String Manipulation(Variable) Excel Writer Open File or Folder Variable Loop End Open File or Folder

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: mitin.sv
Created at: 2021-03-31
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.2

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

Try NodePit Runner!