Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Customize messages in result pane after running workflow.

Venkatesh23
7 - Meteor

Hello guys,

I have created a workflow along with batch macro wherein,

  • Text input tool accepts 2 dates like the following - '2011-01-01' AND '2011-12-31'. Then a query is made to the SQL server which contains the last 8 years dates.
  • Batch macro then fetches the data for the above mentioned date range.
  • The output tool is to write the data in the SQL server as "Update: Insert if New".


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'".

clipboard_image_0.png

clipboard_image_1.png

Thanks in Advance.

4 REPLIES 4
GiuseppeC
Alteryx
Alteryx

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.

clipboard_image_0.png

 

Hope this helps!

Giuseppe

Venkatesh23
7 - Meteor

Hi @GiuseppeC,

 

Thanks for the Quick response.

 

I'm getting the output as shown,

clipboard_image_0.png

Message(18) is from message tool.

Simple(7) is from the Macro tool.

 

Message tool congifured as shown in below image:-

clipboard_image_1.png

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:-

clipboard_image_2.png

 

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,

 

 

GiuseppeC
Alteryx
Alteryx

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).

 

clipboard_image_0.png

 

Hope this helps!

Giuseppe

Venkatesh23
7 - Meteor

Thanks @GiuseppeC 

 

This solution works great for me.

 

Thank you very much.

Venkatesh

Labels