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…
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
@Ana914Variable 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