Alteryx Designer Desktop Ideas

We have a need to be able to trace the lineage of fields being processed through Alteryx - and it has to be done at a field level to satisfy our regulator.   In essence, we have to be able to show exactly where a particular field came from, and demonstrate that we can trust this field.   NOTE: If we could do this - then we could also use this information to make EVERY canvas faster, by checking for unused fields and making suggestions to remove these unused fields early in the flow.

In order to do this - it would be great if there were an option to force explicit field names in the Alteryx XML so that we can trace a specific field.

• Alteryx currently only makes a note of a field name if it is changing that field which is very economical - but it makes tracing fields impossible.
• Desire is for every tool to write the field list to the XML definition for every field that it knows about (just like it looks in the UI)

cc: @AdamR_AYX @jpoz @Claje 

Example:

Here's a simple canvas:

- 3 fields coming in from an input

- Select tool with these 3

- output of three fields into a file

These three fields are not mentioned anywhere in the XML

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.

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!

The Input Data tool has a "Field Length" option for CSV files. The default is 254 characters. In most cases, this is woefully inadequate. I tend to add several zeroes to the end to prevent truncation. When I don't remember to do this, I get flooded with conversion errors:

"Input Data (2) The field "hours" was truncated in record #38"

I want to set a global default, that I can override per tool, for length so I don't have to do this every time.

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.