How to set up a warning message?

Question

I have used summarize tool to calculate Debit side and Credit side result (as attached)

If I want to have a "Not Balanced" warning message pumped up using Text tool, when they are not balanced. Or a "Correct " message when they are balanced, how can I manage that?

Checking info.JPG

CharlieS · Answer

Hey @Shaopingfu

Check out my virtual Inspire presentation from a while back about error messages (and warnings). It outline the features and functionality and show how they can be used for good.

https://community.alteryx.com/t5/Inspire-Presentations/Error-Messages-Are-Data-Data-Is-good/ta-p/808272

...and of course let us know if you have any questions.

jterryrsm · Answer

You could try using a test tool. I'd add a formula tool on a separate branch that gives a you a new column. The formula would be debits - credits and then connect the test tool to that. have the test check if it is = 0 and if not it'll produce an error on the workflow. No error means they balance. See the test tool examples on how to configure.

WesCannon · Answer

Hi @Shaopingfu , You can use Message Tool to accomplish this using the 'Before Rows Where Expression is True' setting to send a Message or Warning when Credit does not equal Debit. You could also setup a Message when Credit and Debit do match. I've provided an example workflow that demonstrates how to do this.

Hope this helps!

Thanks,

Wes

Debit and Credit Message Example.yxmd

Message.PNG