I have created a complex work flow which includes 100’s of nodes. When the project was assigned it was a one time run for year 2023, now, they are asking to run it every year. I have to change 2023 to 2024 in may be 50 to 60 nodes. Is there a easy way of doing without impacting the workflow
Few examples
I have created variables and used , but the query has bene running from yesterday and extremely slow and did not return results yet
Hi,
do you really need to do this kind of query with this hundreds of typecasts? There must be a more efficient way to get the data correctly.
In general it’s hard to give a general answer but for me it seems there are two ways:
- hard way: check every node
- harder way but risky / expert knowledge needed: all KNIME nodes of your workflow a basically xml scripts. If you have a look into them at your workspace folder you can find all settings, including the “year” expression. Grab a text editor and replace the 24 with 23
@chaithuj if you go thru the effort once you might as well use flow variables if there is a chance to do this again next year. Edit: OK you already did.
Concerning the SQL can you tell us more about the database what type it is how large the datasets are and if this does work when you do not use flow variables.
Also you might want to give us the SQL code or ask a KI for optimization.
If there is a longer chain of (brown) SQL connections it could be an option to break them into steps.