Workflow created for the KNIME forum ...
DESCRIPTION:
The Challenge is collect information from Excel files placed in the header of a spreadsheet, and later incorporate as columns into the Data body. The source files are consistently shaped in a template format.
For this Example I have connected the workflow to a Google Drive file system storage. But the concept can be extrapolated to any other storage system.
For any comment or bug realted to the workflow, please do not hesitate to leave your comment.
DISCLAIMER:
The sharing of knowledge in KNIME Hub by using these examples and models, have only demonstration purposes in the advantage of the KNIME community.
These are meant to clarify theoretical background of mentioned subjects in caption.
I will not be held responsibility for any damages arising from the use of these models in your investment/valuation related work, without taking formal advise.
Workflow
File Management _ Excel Skip Rows and Add Columns From Header
Used extensions & nodes
Created with KNIME Analytics Platform version 4.4.2
Legal
By using or downloading the workflow, you agree to our terms and conditions.