Alteryx Designer Desktop Ideas

Sometimes when you make changes to a filter tool or some other tool's configuration and immediately click on another tool on your workflow, the chanegs you made to your first tool won't register.  The only way to get them to register is if you click the canvas afterwards.

While JSON Parse tool is useful for processing data, it is possible that a name corresponding to a JSON value may contain a period (.) symbol and this can be problematic when you are dealing with a nested JSON value, as Alteryx automatically uses the period character as a delimiter for the JSON_Name column.

 

I would like to propose an enhancement where the user can select the delimiter the JSON_Name column would be created with, allowing the user to select a character not used in the names for the JSON values, therefore eliminating the need to take extra steps (like finding each name with a period and/or writing specialized RegEx patterns) for dealing with the names that contain a period.

Block-Until-Done could be improved through adding time delay option settings between steps 1,2 and 3. An Excel workbook, for example, must be opened and closed before it can be reread or multiple tabs appended which takes time for a computer to process. Often a workaround or custom macro must be used to account for this time delay. A time delay feature directly in the tool would enable a user to customize the delay period between steps and allow for functions external to Alteryx to complete before next step is taken without macros or workarounds. If no option(s) is selected, default parameters would apply.

dynamic select have field information like [field number] and etc.
i appreciate it available in dynamic rename. 

 

since both also manipulate with header.

 

 

It will be very useful if there will be tool that will be actually a template of a batch macro and one for iterative macro.

 

In this way the person can drop the tool to the canvas and connect it to his flow, so there is no need each time to build one.

 

Obviously if there is 1 macro input, a control parameter and macro output as default, then the person can adjust as needed, but at least there will be a ready template to go.

Hello,

For those unfamiliar, static type checking in Python is a process that analyses your code without executing it, highlighting any potential errors such as type mismatches. An example of this is MyPy (https://github.com/python/mypy), this tool allows developers to easily address issues before runtime - which is a personal gripe of Python (and why I love Alteryx so much).

 

I believe that integrating static type checking, such as MyPy, into Alteryx Designer could vastly improve the users experience. A user of Alteryx Designer expects intuitive feedback - generally through the error red exclamation marks or messages, and this change should align the Python tool to the expected functionality.

 

 

Hello,

 

We would like to have further options in the test tool. As of today you can only test if records matches (equality test) , we would like to be able to test also when it is greater (>) and smaller (<).

 

Thanks !

I have been creating tools that access API data that needs a valid token that does expire.  I use iterative macros because I sometimes need to do offsets and loop around but I also need to confirm that the token is still valid and there is a limit of how many time you can generate a token on a run so I don't want to regenerate the token on each loop.  I sometimes can use the filter tool to accomplish this goal but I have to do some weird place holder stuff so it does not error if no data is coming through.  A nice to have would be if you could have it configure like you do the radio button input to say if value is YES then keep this part of the workflow on if value is "NO" then turn off this sections.

Hi all,

 

Hope you are doing well! Recently I have come across a use case where I had to dynamically rename columns based on Field name ánd position. While I was able to come to a solution using a set of tools, it got me thinking: would it be possible to include the Fieldnumber function exactly like already has been done in the dynamic select tool (i.e. 'Select via a Formula - Column Position' example)?

 

For example, one would write: IF ([FieldNumber] = 1) OR ([FieldNumber] = 3) OR ([FieldNumber] = 7) THEN [_CurrentField_]+"_Code" ELSE  [_CurrentField_] ENDIF

 

 

Currently, Control Containers only report in case they are activated:

Info: Control Container (3): Control Container Activated.
...
Info: Control Container (3): Control Container Completed.

It would be very helpful to also get information on disabled Control Containers:

Info: Control Container (3): Control Container Deactivated.

In many programming languages, errors can be thrown and caught so that the final program does not fail even if a procedure or function produces an error.

 

I would like to propose something similar for Alteryx, using the Control Containers. Already now, a Control Container outputs the log in the container to its output stream on the upper right corner:

 

Still, the workflow produces an error:

My idea is to optionally avoid the error output to the log but only report the error through the control container's output log. The error message in the output log should be "degraded" to a warning. The output log of the control container should stay unchanged. The configuration of the Control Container could look like this (addition in red):

This would help a lot if stuff produced by others is used (e.g., third party macros) which might fail while this might be normal behaviour for the workflow.

When you first pull the the download tool onto the workspace the password on the connection Tab is already populated plus you don't see a cursor when you click in the box!  you only see a cursor if click in the box and then type.  Can you please change this so it behaves the same as the the username box and leave it blank?

Thinking you're able to open the config file like you might a macro. You pull it open, adjust/modify it , you resave it. 

It would be cool if we could just drag the normal input tool and drop it on the Dynamic Input, so we could set the template, and save the clicker finger....  It would be even cooler if Alteryx didnt need a template, but thats a different story.  This seems like an easy attainable feature upgrade.  Keep rocking, Alteryx!

i using dynamic input tool a lot. when reading list of sheet. i will simply put a.xlsx|||Sheet1 (as random file name)

 

However, when it run in the workflow. it will verify the existing file (A.xslx) instead. it will stop due to error (old file not found)

 

suggestion:

1. verifying new path (file) and not old path (file) , or

2. option to ignore error

 

Hi Team,

 

Could there be an enhancement made on the Dynamic Input tool to configure based on name.

This idea came up as I wanted to use an excel file and combine all the sheets. Currently, the tool imports data based on position, if there could be an option to import the data to configure the import based on name, that would be helpful.

Hello,

the Python scripts sometimes get lost or updated when the user forgets to save his/her Jupyter notebook.

 

Please enhance.

 

Thanks and best regards,

Fabian Rudolf

I have a workflow that sends an email to ServiceNow to create tickets.  I have another workflow that runs after that one to pull the ticket numbers used for reporting.  I thought I could combine the 2 workflows using a Block Until Done and then Wait a Second set for 120 seconds but I have found that the Email tool "runs as the last tool in your workflow".

 

Is it possible to change the runtime so it runs when called on?

 

 

It would be fantastic if the Detour tool worked outside for a Standard Workflow, and not just for Analytic Apps and Macros. I can think of many instances where this would be very useful.