Icon

kn_​example_​current_​date_​as_​file_​name

current date/time as filename and constant column - using the create temp dir node with java edit variable node

current date/time as filename and constant column - using the create temp dir node with java edit variable node

current date/time as filename and constant column - using the create temp dir node with java edit variable nodehttps://forum.knime.com/t/using-the-create-temp-dir-node-with-java-edit-variable-node/20083/2?u=mlauber71 current date or time as string current date and time as constant column Explore Date&Time in KNIME & Get Best Practiceshttps://www.knime.com/blog/explore-date-time-formats-best-practices locate and create/data/ folderwith absolute pathscreate datav_csv_pathcreate file name asKNIME locationcurrent day&timeExtract path informationsyyyyMMdd=> choose the time formattemp_dir_pathmy_csv_file_ <yyyyMMdd>.csv(in a temporary folder)=> Temp folder will bedeleted at the endyyyy_MM_dd_hhmmss=> choose the time formatv_csv_path_locationKNIME locationcontext.workflow.absolute-pathv_xlsx_pathcreate file name withABSOLUTE Pathmy_xlsx_file_<yyyy_MM_dd_hhmmss>.xlsx(in the /data/ folder)v_xlsx_path_locationABSOLUTE Pathcreate the sub-folderwith todays datev_daily_folder_pathcreate daily path name withABSOLUTE Pathv_daily_*v_daily_file_pathcreate daily file name withABSOLUTE Path/my_daily_folder_<yyyyMMdd>/my_xlsx_file_in_daily_sub_folder_<yyyyMMdd>.xlsxDate_Timeyyyy-MM-dd'T'HH:mm[:ss[.SSS]]Collect LocalMetadata Data Generator Java EditVariable (simple) Create Date&TimeRange Path to URI URL to File Path Date&Time to String Create Temp Folder Variable toTable Row Path to String CSV Writer Date&Time to String Table Rowto Variable Table Rowto Variable String to Path(Variable) Extract ContextProperties Java EditVariable (simple) Table Rowto Variable Excel Writer String to Path(Variable) Create Folder Java EditVariable (simple) String to Path(Variable) Java EditVariable (simple) Excel Writer ConstantValue Column String to Date&Time current date/time as filename and constant column - using the create temp dir node with java edit variable nodehttps://forum.knime.com/t/using-the-create-temp-dir-node-with-java-edit-variable-node/20083/2?u=mlauber71 current date or time as string current date and time as constant column Explore Date&Time in KNIME & Get Best Practiceshttps://www.knime.com/blog/explore-date-time-formats-best-practices locate and create/data/ folderwith absolute pathscreate datav_csv_pathcreate file name asKNIME locationcurrent day&timeExtract path informationsyyyyMMdd=> choose the time formattemp_dir_pathmy_csv_file_ <yyyyMMdd>.csv(in a temporary folder)=> Temp folder will bedeleted at the endyyyy_MM_dd_hhmmss=> choose the time formatv_csv_path_locationKNIME locationcontext.workflow.absolute-pathv_xlsx_pathcreate file name withABSOLUTE Pathmy_xlsx_file_<yyyy_MM_dd_hhmmss>.xlsx(in the /data/ folder)v_xlsx_path_locationABSOLUTE Pathcreate the sub-folderwith todays datev_daily_folder_pathcreate daily path name withABSOLUTE Pathv_daily_*v_daily_file_pathcreate daily file name withABSOLUTE Path/my_daily_folder_<yyyyMMdd>/my_xlsx_file_in_daily_sub_folder_<yyyyMMdd>.xlsxDate_Timeyyyy-MM-dd'T'HH:mm[:ss[.SSS]]Collect LocalMetadata Data Generator Java EditVariable (simple) Create Date&TimeRange Path to URI URL to File Path Date&Time to String Create Temp Folder Variable toTable Row Path to String CSV Writer Date&Time to String Table Rowto Variable Table Rowto Variable String to Path(Variable) Extract ContextProperties Java EditVariable (simple) Table Rowto Variable Excel Writer String to Path(Variable) Create Folder Java EditVariable (simple) String to Path(Variable) Java EditVariable (simple) Excel Writer ConstantValue Column String to Date&Time

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: 2019-12-16
On NodePit since: 2019-12-20
Last update: 2024-04-20
Created with KNIME version: v4.7.8
Tags: cvscreatefoldertimestampcurrentdaydatetime

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

Try NodePit Runner!