Alteryx Designer Desktop Ideas

I keep making the same changes to the table tool rules, using the same formulas when I build new reports. For example, Row Rule 1: Font, bold; Background Color, green; Row Rule 2; Font, bold; Background Color, blue; Row Rule 3; Font, bold; Background Color, yellow. Each is based on a formula:  IsEmpty([Column Name]). I do this over and over and over again. The only thing that changes is the column name. It would be nice to have the Row Style Rules saved so they can be browsed to" or inserted.

Still waiting for the Default Table Settings to include "CENTER" in the header tab.

In the Union Field, we have the option to manually configure fields.  This is currently done horizontally, which makes it difficult to see every field (if dealing with lots of columns), if we could have a tick-box, and switch this to vertical, then we could use a view similar to the select field. 

Thanks

Sam7

There are currently 7 data types related to numeric values, including byte.  Simply and standardize the way Alteryx handles numeric values.  Condense the numeric data types to one and provide a way to control the decimal places by indicating how many are needed to the right of the decimal.  The current numeric datatypes are confusing and do not behave the same with the formulas functions, like Round.

Adopt the standard numeric functions seen across multiple tools and languages like Excel, SQL, etc;  like RoundUp, RoundDown, AbsoluteValue, Integer, etc.  

Similar to "Start here" dataflow, it would be useful to specify a path within the User settings to open a dataflow "template" file when the users do not have permission to add or replace "start here" dataflow.

Within our organisation, we are required to have the dataflow summary. We have prepared a dataflow to meet these requirements but currently unable to share it like "start here" template so that every Alteryx session opens the agreed datalow "template" file.

Hello, I noticed today when changing the database that my connection string is linked to that Alteryx Designer did not require my password to be reentered.  See below:  This is the initial state of the connection string:

Notice that the database ends in "...-dev" and there is an encrypted password embedded in the string.  So far, all that is fine because that's how I set it up.  However, I typed a different database to end in ...-dev-data-migrations" in the string (while keeping the same server) and expected to be prompted for the password again, but the connection was made with the existing password and I was not prompted to reenter it (see below):

While this is convenient, in my mind this represents a security problem because someone could set up an associate with a connection and only want them to be able to access that server, db connection, but might inadvertently be allowing them a connection to any other database in the same server that happens to share the same password. 

This is all the more risky considering it's standard practice to wipe out the password to a saved connection whenever there's a change to that connection.  These are standards in Microsoft SQL Server Management Studios, Oracle SQL Developer, and most likely many more.  I would even go so far as to say it's an industry standard to wipe the password whenever a change is made.  It's even standard with other elements of Alteryx Designer.  In the data sources quick connect window, you're unable to change the database after a connection was made to one database using SQL Authentication as is shown below:

Notice the existing user name and password combination only allows the one single database connection. 

I think it makes sense to change this so that the password is wiped out whenever any change is made to the connection.

recently loaded the new V11 and gettting used to it.  one immediate gripe is the new version of the Formula Tool no longer supports multiple field actions.  In the prior version I could change Data Types on many fields at once.  I could move multiple fields in a block at once.  there were a few other things but these are things I am sorely missing on my first use of V11.  I created about 20 fields in quick succession just getting names down and then going back and putting in formula which were variations on a theme.  When done I noticed the default DataType was V_WString and I wanted integer.  In the past it was no big deal because I could select the block or interspersed fields and then right click to change data type for all to the same data type.  it was very handy and now appears to be gone.  please bring these things back.

Could you please support Redshift as well?

https://help.alteryx.com/2018.2/PredictiveAnalytics.htm

Hello Alteryx fans and Devs!

For the Summarise tool - would it be useful to have a "Rank" option for the potential Summarise options we can use? Just a thought!

It would be helpful to have one of the following methods to disable output modules to prevent overwriting output files each time a workflow is run:

- A global 'Disable All Output Modules' option, which would effectively mute the workflow without removing any connections

- A module-specific 'disable/enable this module' option, to the same end

I would like to see the pencil (that means writing to a record) go away when the Apply/Check button is clicked.

It will be really useful if the Microsoft Query (aka MS Query, aka Excel Query) can be incorporated in the formula tool. This can make the workflow small and make the tool more powerful

Hi,

I am using the Interactive Chart to create a line-chart, but I would like to have values of (X,Y AND Trace Name)

I cannot display it for the différent regions, when we move the mouse over the curve the parameter is applied only for one region.

FI: it works if i modify the xml code by adding the following code to each region:

<value>
<hoverinfo>x+y+name</hoverinfo>
</value>

Is it possible to add it directly in interactive chart ?

Thank you.

Is it possible to have a "Run Workflow" option in the right click dropdown menu?

Sometimes you may just want to run the workflow at random from the convenience of your desktop without using the Alteryx server's capacity. When that is the case, you have to open the workflow, wait for it to load in Alteryx, and click "run" from the canvas. Instead, I would like to right click the workflow's file path and click "run workflow" from a dropdown menu without opening the workflow itself. When the file is complete, I can either receive a pop up to inform me it is complete, the time it completed, and the runtime or I will just know by checking the date/time modified in my output file. And if you have disabled all output in that specific workflow or it writes out to a database, an email, a server, or somewhere else that may not be able to handle this new feature, the "run workflow" could simply gray out in the dropdown menu to indicate it is not an option for that workflow. I think this would be a very nifty feature for your .xlsx, .tde, .txt files, etc. that output in the same file directories,

Thanks for reading!

One idea that could help a lot of users while preparing dashboard solutions where we might need to attach artifacts for proof or references that might have helped us in developing the dashboards. 

For some workflows I see the value of concentrate a high number of formulas in a single Formula Tool, specially when you have a considerable number of simple and independent formulas. This makes future changes to the workflow easier, since you (and other in your team) know where exactly to find the formulas in a workflow. But as higher the number of formulas in Formula Tool, more difficult is to find a specific formula in the tool.

My suggestion is to implement a sort option - so you list the formulas/columns alphabetically - and/or a filter option - bringing the relevant formulas/columns as you type. 

Since I am relatively new in the Alteryx world,I am not sure if there is an alternative for that (officially or unofficially speaking).

Thanks. 

Hello,

I really apologized if this has been posted before with some other title.

I started with Alteryx month ago and I am really trying to replicate some cool stuff for which we used to write ETL code in Python and loved it.

I saw a lot of posts regarding a Join Tool for left outer join or right outer join. While using Alteryx as a new person even I was confused with the Join tool since I was missing on numbers and ratios then I used Union Tool to union left and inner anchor of the output for the desired output.

I believe there should be a checkbox in the Join Tool for the Union Tool option.

I know its just a matter of dragging one more tool on Canvas but this is regarding with more flexibility and ease of use for every Alteryx user.

Thank you.

Regards,

Owais