Hello guys,
I have created a workflow along with batch macro wherein,
I am currently seeing the output like this.
But I need the message in result pane as shown below.
"Number of records read : 1952 '2010-01-01' AND '2010-12-31'".
Thanks in Advance.
Solved! Go to Solution.
Hi @Venkatesh23,
you can use the Message tool to write custom messages in the Results pane. in your case you'll need to use the Summarize tool to calculate the number of records (count) and use it as an input variable of the Message tool.
Also, you may be aware of this already, but if you use this within a macro, you'll need to check the 'Show all macro messages' option in the workflow configuration.
Hope this helps!
Giuseppe
Hi @GiuseppeC,
Thanks for the Quick response.
I'm getting the output as shown,
Message(18) is from message tool.
Simple(7) is from the Macro tool.
Message tool congifured as shown in below image:-
Where [RecordID] is RecordID tool,
[DateDiff] is Text Input tool where the Date range is given as '2010-01-01' AND '2010-12-31'.
This how workflow looks:-
But i need the output as "Macro message and message tool message"
like "No. of records:- 1952 '2010-01-01' AND ''2010-12-31'
"No. of records:- 2179 '2011-01-01' AND ''2011-12-31'
"No. of records:- 2241 '2012-01-01' AND ''2012-12-31'
.
.
and so on.
Thanks,
Thanks for clarifying, @Venkatesh23.
If I understand correctly, at each iteration you want the message to show the dates and the number of records read for that specific iteration.
I have mocked up the changes that I would apply to your macro to achieve this (see below and attached).
Hope this helps!
Giuseppe