error in message type

Question

hi. my workflow is almost completed but can someone help me improve my workflow to achieve the following criteria:

1. if data row is not more than 56 rows and the net difference field didnt exceed +/- 25 per row, prompt a message type " no further action needed"

2. if data row is more than 56 rows and the net difference field didnt exceed +/- 25 per row, prompt a message type " Data rows exceed 56 rows. further action needed". create a output file of CSV
2.if data row is not more than 56 rows but the net difference field exceed +/- 25 per row, prompt a message type " Net difference exceed +/- 25.. further action needed". create a output file of CSV

i'm erroring out everytime i used the messagetype

i've attached the 3 sample input file for the 3 scenarios and the drafted workflow.

SCBDOTB02D_TB_RECONCILE(notmorethan56_noexceed25).csv

SCBDOTB02D_TB_RECONCILE(morethan56_exceed25).csv

SCBDOTB02D_TB_RECONCILE(morethan56_noexceed25).csv

TB_Test1.yxmd

jrlindem · Answer

I like @Turtite's recommendation to use Formula's, Filters, and Message Tools.

If you need the workflow to do more than just tell you what is occurring, but actually perform some set of tools if within tolerance vs a different set of tools (like email you and do nothing else) if outside of tolerance than consider using Formula, Filter, and Control Container to accomplish conditional execution of your workflow, making it more dynamic.

Here's an article that will provide info on this:  Tool Mastery | Control Container - Alteryx Community

Turtite · Answer

Ensure you're using conditional logic tools like the Formula or Filter tool to handle your criteria. For message prompts, consider using the Message tool for clear outputs, and double-check your configurations for each scenario.