Analytic app not working from canvas

I have an app that works fine If I run it using the magic wand, however If I try to run the same app from inside the canvas (right click>Edit in the workflow) it doesn't work as expected. In the analytic app, one of the things that the workflow is supposed to do is save a date/time suffix to the file name using an action tool. But it only works if I run it using the magic wand. It is not necessarily a huge issue. But one of the things that it's causing is that when I use the list runner macro, it actually works as if I was opening the workflow using the right click>Edit, and the date/time in the file name is not added.

I know it was not like this before because I tested several times. But since I'm using alteryx in the server of the client, I feel like there might be some configuration that changed this behaviour. Does anyone have an insight for this? (Alteryx version is 2021.3.5)

Thanks.

Workflow

Developer

Developer Tools

Output

Tips and Tricks

Custom Tools

Date Time

Best Practices

Bug

Apps

Interface Tools

Accepted answers

MatthewO

Got it. My recommendation would be to convert the write step to a Batch Macro and pass the timestamp in through the Control Parameter. Alternatively, if you kept it as an app I’d recommend adding 1 interface tool. The action tool defines what gets updated in the workflow so you wouldn’t actually need to use the input. Again, apps expect input so that may be why you are experiencing strange behavior.

All comments

MatthewO

@jackersantos if I am following correctly, this would be the expected behavior. A macro is intended to execute inside of another workflow. At runtime, the data, or pre-configured inputs are passed into the macro and you will observe the dynamic results. An analytic app cannot be used inside of another workflow, it expects user input. The inputs are only passed to the app when it is run as such by clicking the magic wand in Designer, or by publishing to Server. You can confirm the workflow type in Configuration window:

jackersantos

@MatthewO I understood what you mean. But these apps don't require any inputs from the user. In fact, they're only saved as an app because I used an action tool to update the file name with a formula that adds a suffix with the date/time of the execution. Running it from canvas or from the magic wand shouldn't make any difference in my understanding.

MatthewO

@jackersantos analytic apps expect user input and you can encounter errors when they do not have interface tools. Have you explored using the DateTimeStart() function in a Formula tool which will populate the timestamp of when the workflow began executing?

jackersantos

@MatthewO I'm using a data lake file output tool, and using also an action tool to pass the formula with datetimenow() to update the suffix of the file name in order to add the time of execution to the file name.

That is why I can not use a normal formula tool to add this suffix to the file name in my understanding. And because of this action tool the workflow turns into an app that do not require input from user.

MatthewO

jackersantos

@MatthewO Maybe the batch macro option is the way to go. Thank you for your insights!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335