Alteryx Designer Desktop Ideas

Designer only shows the current log during execution or the most recently executed log in the wf results pane. Please add a button underneath the hamburger menu that allows the user to see all of the logs of this wf executed during this session, or, even better, associated with this wf for all time. Please.

I would like to share my idea that would be definitely useful for fast automation of the process with reading and correctly recognizing the text from PDF input. I wrote about that, hoping somebody has already thought about that here.

The idea is the tools "PDF Input" and "Image to Text" from "Text Mining" category to be improved, so as the text from PDF document to be read properly, no matter the text position on each page. 

It could be also considered the performance of the combined tools of "PDF Input" and "Image to Text" to be improved as they work slower than the customized tool PDF Input does.

The idea also can be expanded to an entirely new tool that works out all the actions, needed for correctly reading of a PDF document without manual intervention.

Hi All,

I had posted in the Tool Master | Unique thread about how when I use this tool it does not preserve my sort.

This seems odd to me. I understand that it's "a blocking tool and that records are then sorted prior to executing the tool process" as @TaraM points out. However, in a program where data is explicitly manipulated to a condition, there is an expectation on my side (maybe mistakenly?) that if I sort something that it would not be changed unless stated or indicated in some fashion. 

For my use case I was sorting to eliminate the duplicates, then joining that data to eliminate other duplicates and outputting the resultant to my users and future-state will be automatically fed into a system, for each stage it matters that the sort function is kept intact.

I know it's a simple complaint / fix, but its unexpected behavior on my end and could mean less confusion and less tools on the board. which is always a good thing in my book.

Wonder if it would be possible to have a set of SQL tools in Alteryx which to the user would look like you are dragging in a tool to manipulate the data (such as filtering data) but in the background it is updating the SQL (such as adding a WHERE clause) meaning the module runs faster. This would be easier than having to manually update the SQL code and would run quicker than bringing all data through and filtering afterwards.

I know there is currently the Visual Query Builder, but this is quite fiddly to use so would be good to have something more user-friendly.

While there are many keyboard shortcuts, we primarily interact with the workflow using the mouse. In order to improve efficiencies and easily create saving habits, we should have the ability to Save our progress by right clicking on the workflow tab. Ideally, it should have Save and Save As. 

Current:

New:

On the canvas, underneath the Run button, there are zoom out and zoom in buttons. It would be lovely if between them existed a number box indicating the current zoom level of the canvas. This would operate much like my web browser, which typically shows 100% unless I have zoomed in or out. Bonus points if the button is clickable to reset to the default zoom level.

Currently, when sharing a workflow with a Python-based connector such as Google BigQuery, the credentials for the tool have to be reentered if the workflow is opened on a workstation different from where the workflow was created or by a different user on the same workstation. 

There is no need to re-authenticate when publishing a workflow to run by a Server schedule or on the Gallery. This functionality should be extended to sharing the workflow between workstations with the Python registry key enabled.

Hi Team,

As the formula design that able to stack multiple formula in once. There should have more things there.

1. Error Icon for formula have Error

Can you find which row have error in seconds?

We had to count to find which formula had error!!!!

and how about now?

At least, do have an icon or anything significant thing that let us found it in second and WITHOUT COUNT!!!

2. buttons to expand all/ collapse all.

It was normal that we need to review formula in again in future.

So, you need to click one by by to view all the formulas?

I have 5 containers in my workflow that don't all need to be run every time. I could play the game of manually enabling and disabling them depending on the need that day, but that quickly becomes a hassle with larger workflows. It would be much more efficient to have a functionality somewhere that displays all my containers with a checkbox of which ones I want run and the ability to set the run order I specify so I can make sure my 'Data Pull' container always runs first. An option to select/deselect all containers would be nice to, and maybe the ability to rename my containers much like the select tool does for fields. 

For any tool that uses the IF, THEN, ELSE or IIF statements, let the ELSE statement be optional (like in Python)

For example, notice in the proposed idea there is no ELSE statement, or a third parameter in IIF:

In Interactive Charts, the only way to get user-defined input (other than automatic axis names etc.) into the chart is to add an additional column to the data which has the same content in each row and to use a batch chart.

I have two suggestions to this point:

1. I would like to allow access to global Alteryx variables in any Chart text, such as "The path is [Engine.TempFilePath]". This should also work for non-batched charts.
2. The current way of referring to columns in batch data is a bit odd and inconsistent to other tools. You have to type in "$" and get a list of available columns. After selecting, the dynamic test appears like static text in the configuration: If you type in "The column name is $column", you see "The column name is column" afterwards. That's quite confusing. My suggestion is to use the same nomenclature as elsewhere in Alteryx: Type in the text in brackets: "The column name is [column]". That way it would be as usual.

When enriching your date data, week information is pretty critical, I suggest adding %w to the format stings as well..

Several month based expressions can also be made weekly, data time first of week #31, last of week #45 etc....

Also came across a lot of questions at our community on how to turn week based data...

Writing the formula is obvious (Ceil(DateTimeDiff([Today],[Date],'days')/7))

but having a DateTimeDiff([Today],[Date],'weeks') is preferable don't you think?

Cheers

I'd like to see the size of the data processing through each tool, in say GB. This would be helpful in understanding the volume of data being written to connected systems and would also be useful when cleansing data to determine if a meaningful impact was made to the data cleanliness.

When giving a user a dropdown list, it is difficult to give them an option of the data in a specific column.  So if I have a "State" column, I would like to give the user a dropdown of all of the states currently represented in the table.  So if there was "Nebraska, Nebraska, Iowa, Kansas, South Dakota", the dropdown list would give them an option to select Nebraska, Iowa, Kansas, and South Dakota.  This could be useful on both List boxes and Dropdown lists.  Currently there is a workaround that lets you do it, but it is not a great solution because if there is a space (Like in South Dakota), it puts an underscore in it so parsing is required.  

Please enhance the Join Multiple tool to include an option of:

"left outer join all on input 1".

Such a tool would be massively advantageous when data granularity is defined by one dataset (input 1) and many subsequent tables just need to be joined onto that input.

As-is, I have had to manually perform dozens of join + union sequences which seems both untidy and inefficient.

Such a feature would likely be more useful than existing options of full outer joins / inner joins which currently the tool allows.

I love the new (relatively) ConsumerView Decoder Tool! I used to do it the hard way, and it was fragile.

However, one thing is still missing: the Mosaic fields (MOSAIC HOUSEHOLD and MOSAIC ZIP4) - these are output from the tool as nulls. So, not only do you not get it decoded, you have to join back to the input to get the fields back as they were.

First, at least please pass them through as they were.

But preferably, decode them to the Mosaic Segment/Group names.

I realize (or couldn't find) the source for the Mosaic segment definitions is not currently in a Calgary database, but the tool is in the Calgary group.

The ability to Sort and Filter in the Results window is a huge time saver. Please allow the same functionality when viewing results in a new window.

I was able to add the following lines of R script to get the importance of the variables used in the cluster analysis. This will allow the user to see what variables are important in determining the clusters they have. 

The script I added is below. It is pretty basic and could used spruced up by an Alteryx engineer as far as column naming,  accounting for contingencies, and making it a reporting function.  I think this would be a valuable feature for future versions of this tool. 

library(FeatureImpCluster)#load library
FeatureImp_res <- FeatureImpCluster(clus.sol,as.data.table(the.matrix)) #Use FeatureImpCluster to take the cluster model (clus.sol) and data (the.matrix) to get variable imp.
FeatureImp_df <- as.data.frame(FeatureImp_res$featureImp) #turns features from a list to dataframe
FeatureImp_df_rn <- tibble::rownames_to_column(FeatureImp_df, "Variable") #Adds the variable name to the importance scores
write.Alteryx(FeatureImp_df_rn, 3) #outputs dataframe in output #3

The new enhancements to the Input tool, File, Excel file type being able to input a named range is fantastic!

One trick I use often when creating a template Excel file for user input is I give the form sheet a "Code Name" - sadly in Excel this cannot be set when creating the template using code or from Alteryx - it needs to be set manually in the <alt><F11> IDE, select the sheet in browser then set the code name in the properties window. Advantage: the user can change the visible label/name of the sheet to their liking but the code name does not change - therefore, an automated pipeline with a fixed sheet name for import (like a workflow picking up files dropped into a drop folder to ETL new results into a database), could reference the sheet code name and not be prone to workflow failure if the user changes the name of the sheet.