Automation of KNIME workflows

[Ramakant_Patil]

I want to automate my knime workflows. I am using the KNIME Analytics platform without any server license.
I tried with the cmd command editor, and I found the code below-----

“C:\Program Files\KNIME\knime.exe” -reset -nosave -nosplash -application org.knime.product.KNIME_BATCH_APPLICATION -workflowFile=“C:\Users\RRR227247\KNIME_EC_MONITORING.knwf”

It is now working, but the issue is that it only generates the final output file without updating the entire KNIME workflow. I just want to reset the flow and execute the flow So that I can get real-time updated workflow.

I automate this .bat file through the Windows task scheduler.

[MartinDDDD]

Hey there,

the best resource I know of is this Medium article by @mlauber71 :

KNIME Batch Processing on Windows and MacOS

I am not quite sure what you mean with:

I just want to reset the flow and execute the flow So that I can get real-time updated workflow

Can you maybe elaborate a little more on what you want to achieve?

Real time for me could mean that you schedule it like every minute to provide the output etc…

[Ramakant_Patil]

Thanks for reply,

Real time means once in a week. Now I am getting output but it is only overwritten the final out as it is without updating the workflow. Means every time I get same data.

[MartinDDDD]

Ok so I think you’ll need to parameterize part of your workflow. Given that you want to run it once per week I take that data will be depending on the date and right now the date is hardcoded?

Maybe you can share your workflow with dummy data then we can help you make it dynamic…

[rfeigel]

If your workflow points to the same file and it doesn’t change on each execution obviously you’ll get the same output. You can try copying your new file to a folder by itself and then read it like this. After its read you can delete it so the folder is fresh for the next execution.

Here’s another approach which should work if you have dates in the file.

Get only the excel file with the latest date in its name

Hi folks, hope you’re keeping well! I’m just newbie to KNIME, and it looks like I start to love this platform, I need your help with something maybe it’s easy for you but not for me I have a list of Excel files with this naming format : name_DateOfYesterday.xlsx like below. [image] are there any ideas how can I only get/load the file with latest date in its name? for the above list of files, I’d like to load only the D_22-04-2023.xlsx Thanks a lot for your help.