Alteryx designer Discussions

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

Working with marco outputs

Highlighted
Alteryx Partner

Hey!

I have develeop a marco(A) inside the the macro(A) they are calling other macros(B, C) (see: http://community.alteryx.com/t5/Publishing-Gallery/Call-Macro-with-other-Macro-inside/td-p/5025)

In the macro(A) I define no Macro Input Tool.
In the macro(A) I define a Macro Output Tool.

The macro are processing user inputs together with macro(B, C). At the end, the macro(A) write a csv-file with concate row of the calculated results from macro (B, C) by

the user inputs from macro(A,. B, C).

When I run the  macro(A) alone, the macro(B, C) calcuale the necessary results.
I think it is working fine.

1) Now I build a new Workflow(Standard Workflow) and insert macro(A) and connect macro(A) to a Browse Tool.

I run the Workflow.

Then I look to my result row.

The nessary outputs from the macro(B, C) inside macro(A) are not in my result row. I think it did't call. Why?

2) Then I change the the workflow type from macro(A) from Standard Macro to Batch Marco. (nothing else)

Now I build my Workflow(Standard Workflow, W1) again.

I insert marcro(A) again.

Now is the inserted macro(A) require a input connection. Why?

I insert the csv-file this was created by excecute marco(A), for the input connection of the inserted macro(A) into W1. In advance run macro(A) frist, to create the csv-file.

Then I connect the macro(A) to a Browse-Tool again. I look to my results ain my Browse Tool. My result row was complete.
Everythink is O.K.

But that is not what I want ;-((

What is the difference between Standardc and Batch Macro
Where is the bug by excecute the workarround 1)?

works o.k.woks not o.k.

 

 

 

Mathias

 

 

Alteryx Certified Partner
Alteryx Certified Partner

Can you share a screenshot of the inside of the macro?

 

At batch macro allows you to run a macro once, or several times, for a set of "control parameters" fed from the data in the parent module. e.g. the control parameter might ask for a filename and you could run the macro once for each filename in the dataset passed to the control parameter.

Highlighted
Alteryx Partner

Addition:

 

The same correct result I get when I use the Batch Macro with a Text Input Tool with a dummy row inside.

workarround_is_ok_text_input_tool.PNG

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

If you haven't connected a control parameter up to the macro then this is expected behaviour. Perhaps you can provide a few more details on why you think you need a batch macro? or are you just trying it to see if it fixes your issue?

Highlighted
Alteryx Partner

Hey !

The macro display is to large for one screenshot, I spit the macro-screenshot

macro_A_top-left.PNGmacro_A_top-right.PNGmacro_A_bottom-left.PNG

Highlighted
Alteryx Partner

Hey Chris!

 

The batch macro I use only fixe my issue!

 

It is not what I want, I want to use a Standardm Macro.

 

Mathias

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Okay given the complexity I think I'd refer you to your local Alteryx Partner Support / Client Services. It's very hard to see and advise without a screenshare.

 

Some general hints:

 

1.You don't need a batch macro unless you intend to loop over several results

 

2. To use a batch macro you MUST have a control parameter interface tool

 

3. Ensure every question in the macros B and C have interface tools that expose that question to A, so you can run those with the questions you have from the user in the parent module.

 

Sorry I can't help more.

Highlighted
Alteryx Partner

Hey!

 

The Batch Macro I use have not control parameter interface tool.

But it is the only workarround that works correct. Strange for me!

 

textbox-tool_connect_to_batchmacro.PNG

 

 

 

 

 

Highlighted

Thanks...

 

 

Labels