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