Icon

kn_​forum_​28215_​match_​excel_​file_​names_​and_​dates

Join data in KNIME from date/timestamp in name of imported Excel file

Join data in KNIME from date/timestamp in name of imported Excel file

Join data in KNIME from date/timestamp in name of imported Excel filehttps://forum.knime.com/t/variables-in-reading-excel-files/28215/10?u=mlauber71 original dataconvert to DateList ExcelFiles from/data/ folderextract date partDateSTARTNode 31constant valueDatejon information fromimported excel filecollect the informationENDFilter for day from Exceldata/result.table Table Creator String to Date&Time List Files File Meta Info String to URI URL to File Path String Manipulation String to Date&Time Table Row ToVariable Loop Start Excel Reader (XLS) ConstantValue Column String to Date&Time Joiner Loop End Rule-basedRow Filter Table Writer Join data in KNIME from date/timestamp in name of imported Excel filehttps://forum.knime.com/t/variables-in-reading-excel-files/28215/10?u=mlauber71 original dataconvert to DateList ExcelFiles from/data/ folderextract date partDateSTARTNode 31constant valueDatejon information fromimported excel filecollect the informationENDFilter for day from Exceldata/result.tableTable Creator String to Date&Time List Files File Meta Info String to URI URL to File Path String Manipulation String to Date&Time Table Row ToVariable Loop Start Excel Reader (XLS) ConstantValue Column String to Date&Time Joiner Loop End Rule-basedRow Filter Table Writer

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: 2020-11-10
On NodePit since: 2020-11-11
Last update: 2024-05-01
Created with KNIME version: v4.2.3

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

Try NodePit Runner!