Hi, I have an issue with with macro, where I have attached an input file going in and a browse tool coming out and I run the workflow and everything is great. However, when I try to attach another tool such as a select or union, they can't seem to find the fields. I have a couple more macros on other workflows and they seem to work fine. I have spent a few hours trying to figure this out and can't pinpoint it. If I go into the macro and run the workflow then I do get one warning, but only for a column with a duplicate name, which I remove with the next tool anyway.
Anybody have any idea what could be causing this. Apologies, I can't share the workflow as it contains sensative data
Solved! Go to Solution.
I think may have resolved this. It looks like the issue is with the data cleansing tool being the last thing in the macro workflow. I have added another select tool and it appears to work fine now.
Thanks for this. I've just experienced the exact same issue with the Data Cleansing tool as the last element before the Macro Output in Alteryx Designer 2018.1.3.42973 - must be a bug...
Alteryx is aware of this issue. You are exactly correct that you can add a Select tool just before your Macro Output. That will restore transfer of the metadata and error-free operation.