The Message tool allows the user to report messages about a specific process to the Results window.
Select at which time the message is written and sent to the results window.
Before First Record
Before Rows Where Expression is True
All records are passed through regardless if the expression is true or false.
After Last Record
Use this option to capture the row count with the Message tool.
After All Down Stream Tools Have Completed
Use this option to generate a message after an output has completed.
Message Type: Select the type of message the tool writes. For more information see the Results window.
RegEx(9): 12 records were successfully parsed and 0 were not.
RegEx (22): The Value "22 Purple Haze" had too many parts to fit # of output fields.
Formula (13): Code: "12 Alteryx Blue" was truncated
Append Fields (9): The Source must have a valid connection
Browse (13): Missing Incoming Connection
Browse (13): Workflow was Cancelled by Properties Setting
Message (15): Example Test Input File
Message (15): Example Test Output File
Message Priority: Determine the behavior of the tool when it is used inside Macros.
Normal The message is only written when:
Medium The message will only be written when the tool is included in the workflow which is being run OR inside a macro in the workflow. So it will output if it is up to one level deep in a macro.
High The message will always be written regardless of how many levels of macros it is contained in.
Conversion Errors and Errors message types are always High Priority.
When checked, the message replaces an existing message issued by the same tool. This is useful for messages which report tool progress, such as reporting the number of rows that have been processed.
Type the message that will be displayed. This message can be fixed text or can be built up from data fields.
"This tool is reporting a message"
"Age:" + [AgeField] + " is outside the allowed limits."
Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.
After Last Record and After All Down Stream Tools Have Completed: [_RecordNumber_] equals the total number of records passed through the tool.
"Amount of records generated by Text to columns tool: " + TOSTRING([_RecordNumber_]
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.