In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Debtor Macro

BRRLL99
11 - Bolide

Hi

Requirement : 1

I have build Debtor Macro Tool , where my end requirement is IF Count 1 then  Left Anchor tools should run, IF Count > 1 then Right Anchor Tools should run.

 

Attaching developed Workflow for reference......................

 

 

 

                                                                  

7 REPLIES 7
alexnajm
19 - Altair
19 - Altair

What is the question? Have you tested your macro in Debug?

BRRLL99
11 - Bolide

If count = 1, run the Left Anchor tools
If count > 1, run the Right Anchor tools

This is my requirement !!

alexnajm
19 - Altair
19 - Altair

Ok then change your Action tool to Detour the way you need based on that condition - looks like you have it reversed right now. You are saying "True" to Detour Right when it is equal to 1 in your Action

BRRLL99
11 - Bolide

I'm not getting the expected output, Pls share the workflow
could you pls share the formula

Action Tool formula I used : IIF(TONUMBER([#1]) = 1, "False", "True")

@ Value has been highlighted with blue

alexnajm
19 - Altair
19 - Altair

That Formula has worked for me - please make sure you are running the workflow with the macro and not just the macro

BRRLL99
11 - Bolide

when i ran the macro with the workflow

Scenario - 1 : Count = 1 then I'm getting 101 since in the macro for left anchor I'm adding count + 100
But 

Next scenario -2 :  when gave Count = 2 I'm getting output as 1  usually it should run Right anchor and give me output 2 right ??

alexnajm
19 - Altair
19 - Altair

It is taking whatever your value is in the Text Input, not what you are feeding in via the Control Parameter - the Control Parameter is simply affecting the Detour tool. If you want your data from the workflow to also be passed into the macro, change your Text Input to a Macro Input by right clicking on it and converting it.

 

You are right there, final steps!

Labels
Top Solution Authors