Macro output error: Invalid output units

thedr9wningman

Hi Community:

I'm trying my hand at developing a macro again and now I'm hitting a confusing error that is frustrating as all get-out.

I've simplified my macro to do something very similar: It takes my data and stacks it. That's it. It has a function (it's great for spider-maps in Tableau), but it's quite simple really.

But when I run the macro in a workflow, I get this frustrating error: Invalid Output Units. 

After I was done cursing at this, I tried deselecting fields to send to the output, but to no avail.

I'm again bested by macros. Stumped. [sad face]

I shake my fist!

So, with that, please help. What is going on that makes this error happen?

I've attached the macro. 

Rats,

-Cedric

Create OD Pairs.yxmc

MikeSp

Hi @thedr9wningman,

I believe the issue may be how we're passing values via the radio buttons to the tool, with the radio buttons you're passing some "incorrect" replacement values to the Distance tool #39 which I think is causing some confusion. You could create some if statements to update the tool values with the original radio buttons if you want to keep the radio buttons.

I opted for something a little easier to manage, with a drop-down similar to the Distance tool's configuration.

Hope this helps!

Create OD Pairs.yxmc