Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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
18 - Pollux
18 - Pollux

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
18 - Pollux
18 - Pollux

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
18 - Pollux
18 - Pollux

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
18 - Pollux
18 - Pollux

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