Alteryx Designer Desktop Ideas

By being able to connect to views in BQ we'd be able to skip the dependency on scheduling table refreshes within BQ and keep all of the dependencies in Alteryx.

When tools are closely aligned 

Rownum and data size cross with other tools.

 

I would suggest dynamically locating the information sometimes on top or under the tool instead...

 

 

 

When using the SQL output "delete and append" option, I noticed that this is not transactional. I.e. it deletes the data first, then inserts the new data. If an issue happens which prevents the new data insert from happening, then you have lost all the data in the table but it hasn't been replaced by anything new.

 

I tested this by revoking insert permissions from the login I was using - the insert failed, but the delete had already occurred. This could also occur if there was a network error or connection drop in the middle of the execution.

 

I use delete and append because the replace if new option is unutterably slow (takes about 5 minutes to complete on ~3000 rows, instead of 0.5 seconds)

 

I think the delete and append  option should either be enclosed in an explicit transaction, or a combination of temp tables and copying  should be employed. This behaviour could maybe be offered as an option in case of extremely large datasets.

 

Hi - think it would be great to have to open only one debug window, and where I add to my workflow, the debug automatically updates to include the new features of my workflow.

 

As it is now, I believe that I have to open a new Debug window where I have added new components to my workflow. 

@RachelW 

 

I wanted to suggest unhiding select/deselect all in the Options menu for the "select tool".
There is enough space in the header right of "Options" to include select all/deselect checkboxes. or remove the Tip.

Select all/deselect is suppose to reduce clicks. By hiding in Options, it adds clicks. 

 

 

It would be great if Alteryx created a program along the lines of Tableau Reader. If an organization is not at the point where they want to deploy Alteryx Server, but some people need to run Alteryx Apps, making a low cost desktop application that would allow users to open and run .yxwz files would be great. There are many non technical users who don't need and would not use the full version of Alteryx, but creating a desktop application allowing them to run .yzwz files would be helpful to them and would drive Alteryx adoption. 

This is the most minor of annoyances, but it would be great if I could copy and paste color hex values between containers, comments, etc. The system color dialog doesn't have that, so maybe if the color boxes in the configuration pane were directly editable, or something like that. If I'm changing the colors for multiple containers, it's kind of a pain that I have to select the R, G, and B values manually. 

I often go betwen the favorites group and other groups of tools I'm using but might not be considered favorites.  It would be nice if there was a way for a user to put the their most commonly used tools in a ribbon bar on the top near the run button?  The user could quickly grab and drag that tool to the canvas.  IT wouldn't replace the favorites but be an addition to favorites.  What do people think?  Useful or redundant?  Interested to hear what people say.

 

Thanks!

 

 

 

Request to enhance the Snowflake bulk loader upload tool to allow output to be saved on s3 bucket subfolders not only on the root folder

When using the Write Data In-DB component from the In-Database tools, after the insert or update is complete the default behaviour is that the component does a select * from the table.  So if inserting into dbo.customer, once the transaction is complete, the component does a select * from customer.  This behaviour is really useful in some circumstances, e.g. creating reference data then returning all data so you can join back into the workflow, but can also really destroy performance.  Imagine if dbo.customer contains billions of rows.  Of course there are ways of restricting the data that is returned to the workflow, (e.g. use the sample tool), but the query is still executed in the DB.  Therefore my suggestion is to make output configurable.  Would be useful to have a four option output, either:

(1) zero row output (i.e. metadata only),

(2) successful transaction flag & error message if applicable,

(3) count of rows effected, for some DBs you can get this by default (MS SQL Server), or

(4) select * from table, as is now.

 

Thanks, nick

I discussed this with Rithi Son and he suggested I submit this idea for a GUI enhancement. 🙂
Need: I would like the ability to snap size/maximize the floating boxes. This includes config, results, overview, etc.
Current Issue: Currently when these sections are undocked and in floating mode there is no maximize button and no ability to snap the sizing as you would the main GUI of Alteryx (no maximize button and no windows snapping to the side ability to set to half the screen size).
Reason for Change: This makes it difficult to use multiple monitors quickly as it wont save the layout to the monitors on close and adds labor. Meaning when reloading Alteryx it pulls all the floating overtop onto the program’s monitor. I have to manually move the windows, resize manually (often overlapping my monitors due to its current sizing behavior), and then can continue my work.
Additional Workaround Troubleshooting:I know we have the ability to set new window for the results info but I am specifically looking for all floating sections. Including the results section as a whole.

Thanks for helping!

I'd appreciate the ability to use the Find and Replace tool and "Find" on multiple fields as if it were a join. Currently, in order to flag clients (who are repeated across the data set) with some records that I've already isolated that meet certain criteria, I have to create a compound key for the client and the flag and then use Find/Replace on the compound key. I'd rather use a Find/Replace where multiple columns match (ex: Client, Product, Month, Shipping Depot A, etc.) and skip the compound key step if possible.

I have been using Alteryx for not a very long time, but allready feel frustated by the difficulties when it comes to access the data result shown in the Browse Tool (from Linear Regression, Principal Component Analysis, etc.).

Lots of the output shown here is really important data that you really want to be able to access for further analysis in Alteryx or in another tool.

 

This data should be easy to access, following the Alteryx self-service philosophy.

 

 

 

Go on, please!

When running a workflow and outputting files to get a better look at the data if you have forgotten to close one of the output files of the same name, you get the "Error Creating File". 

I understand why this happens and that I forgot to do something.  The issue I have is that it doesnt tell me that those files have been left open until after the workflow is almost complete which in some cases is 5-10 minutes and then I have to close the output files and re run and wait again.  Could a future version check those files at the begining of the process and then let me know, or could there be a message that says "filename" was open and could not be created we have renamed it to "filenameA".  Checking at the begining would be prefered. 

 

Thanks

 

 

 

If you are connecting to an Oracle database you can get faster results with adding a short hint to your SQL query. For a query like this

 

 

SELECT customers.cust_first_name, customers.cust_last_name, 
MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;

 

 

add /*+ PARALLEL(4) */  (or depending on your CPU size 😎 and that SQL becomes this;

 

 

SELECT /*+ PARALLEL(4) */ customers.cust_first_name, customers.cust_last_name, 
  MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;

 

 

There is a similar capability for SQL Server too...

 

SELECT *
FROM Sales.SalesOrderDetail
OPTION (MAXDOP)

 

 

I suggest adding this feature in in-db tools so that no one needs to alter the SQL query itself...

 

You can check out the inner workings for oracle here; https://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm

 

Almost all usage statistics is tracked by Alteryx I suppose, including annonymized workflow xml's too? That is a treasure trove...

 

 

I would like to suggest doing analytics (a simple market basket or a slightly advanced predictive model) to offer me a next-best-action;

 

• either when I click on an output of a tool or  
• clicking on a connecting line in between tools

With what frequency other users selected which tool given the current setting and previous sequence of tools in the workflow...

 

You may call it wisdom of crowds or AI assisted workflow development...

 

 

 

 

 

Best

Hello - does anyone know if it's possible to to place text both above and below a table in the report text tool (in this instance i'm using it to feed an automated email)

 

I have some text which is the body of the email but also want to add some text with a hyperlink to unsubscribe to the email, below a table but as far as I can tell, there's not a way to input the table in between text, only above/below/left/right

 

Thanks in advance for the help,

Harry