Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

CReW macro Wildcard XLSX Input error

wparni
5 - Atom

We have recently upgraded to Alteryx 2012.2.1.35394.

 

Prior to upgrade the CReW Wildcard XLSX macro worked fine.

But now it fails with error "Detour tools in macros must terminate within that macro"

 

It occurs when the "Field names in data" option is deselected.  If that option is selected the macro works just fine.

 

wparni_0-1629416342147.png

 

Any ideas would be appreciated.

4 REPLIES 4
jrgo
14 - Magnetar

@wparni 

 

Check to see if the AMP engine is enabled on your workflow. If it is, see if the issue still happens when it's disabled.

wparni
5 - Atom

Thanks for the quick response @jrgo 

AMP engine is disabled.

Looking at the macro the right side of the Detour connected to that "Field names in data" Checkbox, does seem to eventually terminate with a Macro output.  Apparently that is a no-no since version 2020.# -- at least I read that somewhere else in the community.

FlorianC
Alteryx
Alteryx

I am experiencing the same issue in Designer version 2021.3.4.00445.

 

The actual error message thrown by the macro workflow is the following:

 

Macro Output (92)	Detour tools in macros must terminate within that macro

 

This happens because the tool Macro Output (92) which generates the non-matched output anchor requires data from the right side of the tool Detour (32). It can easily be fixed by adding another Detour End Tool before and linking the Left and Right input anchors to Detour (32) and Sort (98) respectively (adding a sample tool to drop all records from the output since everything will be matched).

 

Wildcard XLSX Input macro hotfixWildcard XLSX Input macro hotfix

 

@wparni Please find attached an example macro with the hotfix implemented.

 

@MarqueeCrew Was this working as expected with previous versions?

Florian Carrier
Strategic Solution Consultant
Alteryx
MarqueeCrew
20 - Arcturus
20 - Arcturus

to my knowledge, but it's nice to see that someone else is testing/using it.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels