Basic question about user input

[Euino]

Hello guys, and thanks in advance for your attention.

I have what I think is a very easy thing to do but struggling at it.

I daily export a collect different files from my bank accounts and want to manipulate and merge them in a single file to be exported to my Microsoft BI.

This is fairly easy and I have already completed the taksk… BUT the bank export for a reason I cannot comprehend doesnt have the actual date. What I want to do is to append the current date to every record of my export and I want to manually insert it.
My idea was to have a node that pop-up at every workflow execution asking me for a date and that date is assigned to every record of that export…

I don’t know if I have been clear enough…

thanks
Lorenzo

[HansS]

Hi @Euino

If you want to insert the date/time automatically (instead of manually), I suggest something like this.
.
gr. Hans

[Euino]

Hello Hans and thanks a lot for your answer, your solution is more elegant compared with what I have in mind.
I’m just a little concerned that is too automatic. Not always this workflow will run exactly on the same day of the reports.
So I would like to investigate a flow like this one you suggested but with an user input in the first node… don’t know if it is easy though

[ipazin]

Hello @Euino,

then use Date&Time Configuration node. You can configure it to output today’s Date and in case you are running workflow on another day simply go in configuration and pick the date you need.

Br,
Ivan

[Euino]

ok thanks mate I think I’ll go for this one, is not the pop-up I have in mind (who reminds the user to update the date value) but I’ll make it work
thanks!!

[Ana914]

Hey thanks for this. Can you elaborate further too, say, I would need multiple constant value columns from the table row to variable input.

Would constant value node still work? As I can see, it only allows one variable per node?

[ipazin]

Hello hello,

@Euino see here for more popup possibility with Java Snippet node:

Popup Window in Workflow

Hey Guys, i got a rule engine component where i have to put in a date which i getting written into the output data table. Is there a way, when i execute the workflow, that a popup window shows up and i enter the date in the popup window field and it gets written in the rule engine component, so i dont have to open the component separately and then execute the workflow. Its basically a easier way for my colleagues to start the workflow without knowing where they have to update the date for the…

Additionally WebPortal feature from KNIME Server offers this and more possibilities:

KNIME Business Hub | KNIME

@Ana914 Variable to Table Column node allows you to create multiple constant columns from your flow variables. Also you can simply use multiple Constant Value Column nodes. Keep in mind that flow variables are available to all downstream node regardless of connection type so you don’t have to connect each node with flow variable (red) connection

Br,
Ivan