Alteryx Designer Desktop Ideas

The new Paste Before/After feature is awesome, as is the Cut & Connect Around.

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Paste-Before-After/idc-p/510292#M12071

What would be even better is to allow the combination of the two. E.G. It is not currently possible to copy or cut multiple tools and paste before/after, as this functionality only works for a single tool that's copied.

Thanks,

Joe

I see many posts where users want to view numeric or string data as monetary values. I think that it would be friendly to have a masking option (like excel) where you could choose a format or customize one for display.  The next step is to apply the formatting to the workflow so that folks who want to export the data can do so. 

cheers,

mark

I recently had an error in a module because an expected variable was not present coming into a formula tool.  My variable, "MONDAY" was not present and the formula MONDAY/3 failed.  The workaround was to union all days into the incoming data and things worked fine.  I would have liked to have an Excel formula like this instead:

IF ISERROR([Monday]/3) THEN 0 ELSE [Monday]/3 ENDIF

Thanks

http://community.alteryx.com/t5/Data-Sources/Connecet-to-an-Orcale-Database/m-p/12575#M956

When use Sql-Server build Stored Procedure where list in the Input Data Tool. So able to work with SPs.

When I use Oracle build Stored Procedure where not list in the Input Data Tool. So not  able to work with SPs.

Oracle, Sql-Server and MySql you can build Stored Procedure.

It would be great if when Alteryx for this Databases have implemented the same functionality.

So it can not be made dependent on the using Database to decide for Alteryx. 

Mathias

Currently the Save Field Configuration, when used with fields in a different order does not give any indication that the ordering will not be saved and reused. It is possible people may use this option without realising.

This should be in the help at a minimum, perhaps in a warning box when used too, but ideally the renames and types should be applied to the columns they came from by Name - not just based on the order of the fields.

I would like to request that the Python tool metadata either be automatically populated after the code has run once, or a simple line of code added in the tool to output the metadata. Also, the metadata needs to be cached just like all of the other tools. 

As it sits now, the Python tool is nearly unusable in a larger workflow. This is because it does not save or pass metadata in a workflow. Most other tools cache temporary metadata and pass it on to the next tool in line. This allows for things like selecting columns and seeing previews before the workflow is run.

Each time an edit is made to the workflow, the workflow must be re-run to update everything downstream of the Python tool. As you can imagine, this can get tedious (unusable) in larger workflows.

Alteryx support has replied with "this is expected behavior" and "It is giving that error because Alteryx is 
doing a soft push for the metadata but unfortunately it is as designed."

In the moment we using Alteryx and Tableau to publish data from the Azure environment. In our focus is to publish the data with the ADLS Connector. For us would be perfect if as well parquet would be supported. In end we are in competition against PowerBI and these software supports parquet files.

R and Python has a very fruitful competition in machine learning circles...

Why not have the python editions of all predictive tools as well so that

we can have an "all R", "all Python" and "R and Python" predictive tools that can be mixed and matched in a single workflow,

a multilingual approach...

When you right click on a macro, and say Open Macro - it opens up a new copy even if there's an existing copy of exactly the same file open already.

Please can you change this to focus on the existing copy by default?    I've wasted hours editing the wrong one, or doing split editing across two copies of the same file.

Pretty much only time I add Browse tools during development now is to get access to the Cell Viewer to examine values better. 

Would love to be able to do this on the output window

Hello Dev Gurus - 

The message tool is nice, but anything you want to learn about what is happening is problematic because the messages you are writing to try to understand your workflow are lost in a sea of other messages.  This is especially problematic when you are trying to understand what is happening within a macro and you enable 'show all macro messages' in the runtime options.  

That being said, what would really help is for messages created with the message tool to have a tag as a user created message.  Then, at message evaluation time, you get all errors / all conversion warnings / all warnings / all user defined messages.  In this way, when you write an iterative macro and are giving yourself the state of the data on a run by run basis, you can just goto a panel that shows you just your messages, and not the entire syslog which is like drinking out of a fire hose. 

Thank you for attending my ted talk regarding Message Tool Improvements.

There should by a Python Tool that is just a code paste (more like the R tool) and allows selection/packaging of venvs, similar to an IDE or we should be able to package scripts with workflows/macros.

A python tool that is easily integrated into macros for powerful and quick custom tools while avoiding Jupyter's failures would be incredibly beneficial. This would highlight how Python and Alteryx can work together, and don't need to be all or nothing competitors in the ETL space.

Jupyter is not a tool that should be used for production level processes - it is for teaching. Nobody has airflow or Luigi spinning up Jupyter and executing code in their ETL pipeline, so our Workflows shouldn't either. Yes, yes I have used to SDK to work around and I have also run scripts from the cmd tool but the first solution is time consuming and imposes a high skill wall and the latter has a lot of moving, non-packaged parts.

You guys have the API to do this and venv management from the SDK already so I don't think it would be expensive to implement.

It would be useful when building apps to be able to put interface tools in containers and disable them.  This would allow an app developer to show users multiple ways of having the app styled without having to have multiple app versions saved.  

If Alteryx encounters an error in a RegEx tool - it throws an error:

 RegEx (9) The field "Field1_Matched" is not contained in the record.

This is a somewhat confusing and misleading error message because the input data and the regex configuration have no "Field1" at all, so the error message does not assist with resolving the issue.

Could you please re-look at the error messaging on the RegExt tool to see if we can make RegEx errors easier to resolve by giving a self-descriptive error message?

Example below:

Here I was trying to tokenize by using the . to represent any character - however Alteryx is struggling with this.

The ability to directly edit the XML for tools is fantastic.

Would love an edit option on the XML view for the workflow.

One slight issue on the tool one is that it doesnt run through the Config UI so the Annotation is not recomputed. Would be useful if the annotation was recomputed post XML edit.

It would be great if Alteryx could better handle Carriage Returns!  If I have a csv file that has Carriage Returns (\r) in the Description field Alteryx displays it like so in the browse tool:

I’m ok that it’s ignoring the carriage returns entirely to better display the data, but the problem is that there is no way to know by looking at this browse tool that there are “hidden” carriage returns in my data. When we try to copy this to excel and it looks like this:

Unfortunately, this isn’t quite how I was expecting it to look. I think there are three related changes I would like to see:

1) Change the copy feature of the browse tool so that it ignores carriage returns (\r) just like when you display it in a browse tool.

2) Make a new character that would display the carriage return when I click the “show whitespaces” button. It shows line feeds (\n) as paragraph symbols but won’t show carriage returns (\r). Here is what the \n looks like if I replace my \r with \n:

My \r character currently doesn’t display at all:

3) Add the red triangle indicator similar to the line feed (\n):

I currently get no warning that there are embedded carriage returns.

Thanks!

Improve "Select Tool" by by moving the select/deselect All from the Options and placing in the header.

The Data Cleansing Tool already has all/none posted in a better position.

Meanwhile you have to go to Option for this same feature in Select.

I love how the new (as of 2018.3) Python tool has a Jupyter notebook in the config panel. Jupyter is great, has a lot of built-in help, and is so robust that there is really no need for an external installation of any Python IDE anywhere else.  I would love to see that with the R tool as well.  For now (as of 2018.3), it's much easier to develop R outside of Alteryx, e.g. in R Studio, and then copy the code in the R tool.

Therefore, this request is to implement R just like Python, using Jupyter. This would allow us to script it and see our visualizations (etc) right in our Jupyter window.  It would eliminate the need to have R-Studio off on the side.  Here are a couple links that may hint how to make it happen:

• http://docs.anaconda.com/anaconda/user-guide/tasks/use-r-language/
• http://docs.anaconda.com/anaconda/navigator/tutorials/r-lang/

Hope you can make it happen -- thanks!