Detour based on 'None' condition in macro

Hi All,

I have a macro where there is a drop down list for a user to select a field - but I also want them to be able to select 'None'

I want to detour the workflow based on if they selected 'None' or not. The way I am doing this is with a Condition tool which updates the action tool to modify the workflow

However, my macro does not divert based on the selection, and I think I have the condition tool incorrectly configured (or maybe the action tool)

My macro looks as follows:

My condition expression is: [#1]='None' , I have also tried IsNull([#1]) but got the same result (workflow does not divert).

I have set the action as "Update Detour Direction from Condition" and updated detour to the Right direction.

Can anyone see what is going wrong with my macro?

Example Drop Down.yxmc

Developer Tools

Macros

Interface Tools

Accepted answers

TonyA

I haven't looked through the macro completely, but the test should be [#1] = "". Here's a simple example app that I put in a yxzp since Community won't let us post yxwz files.

EDIT: I made the changes to your macro and am getting a slew of errors in the formula tools. I stripped out the action tools connected to the formula tools and verified that the detours are working correctly with the [#1] = "" test. But there's something wrong with the way the action tools are updating the formulas.

EDIT2: You need to look at the way the formulas are set up in the action tools. I think your formulas are generating toString(Account ID) without the square brackets on the column name. The errors I'm seeing are reporting an unknown variable "Account"

Detour Test.yxzp

All comments

TonyA

I haven't looked through the macro completely, but the test should be [#1] = "". Here's a simple example app that I put in a yxzp since Community won't let us post yxwz files.

Detour Test.yxzp

Hugo

Thanks TonyA - nice to know the first place I was going wrong 😄

I'll keep trying on the formula updating with the action tools - it's not something I have tried before so happy to muddle my way through it

ChrisTX

This might help to debug a macro:

Community > Blogs > Engine Works Blog > The X-Ray Browse: Macro Debugging Made Easier

https://community.alteryx.com/t5/Engine-Works-Blog/The-X-Ray-Browse-Macro-Debugging-Made-Easier/ba-p/2358

Also:

From Tips and Tricks 2019.pdf, page 73:

ANALYTIC APPS AND MACROS TROUBLESHOOTING TIPS

DEBUG WORKFLOW

Apps and Macros have a debug feature that can be used to verify your app or macro is working as designed.

To use the debug feature, open the Interface Designer (Views > Interface Designer) and select the Test View (button on the left). Fill out the information requested by your app or macro, then click on Open Debug.

A debug workflow will open as a new tab in your current Alteryx session.

(A copy of the workflow will open called Debug Workflow# (# being some number))

Run the debug workflow to make sure it is creating your desired results.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335