Alteryx Designer Desktop Ideas

I have records of with several address fields per store: address 1, address 2, address 3.(e.g. po box 123, 456 main st, suite 600).
I geocode each address field in different iterations, but I want my final input to contain the best geocoding level. e.g. Actual before Zip9. 
Can we rank the geocoding levels like this below? Then it will be easier to filter out the best geocoding level.

Integrate matchit SQL with Alteryx

http://matchitsql.com/

Currently I am unable to use Alteryx's spatial calculations in completing required reporting for CMS.  Its unfortunate, because in my mind Alteryx is a superior approach allowing for customization and seamless integration with varied data sources used within our company.

You might ask, why don't you just use actual driving distance?  The datasets that we are measuring are enormous. +60M member files are being compared to 70K providers.  Alteryx is missing a huge opportunity to get into this market.

Reference

https://www.cms.gov/Medicare/Prescription-Drug-Coverage/PrescriptionDrugCovContra/downloads/hsd_meth...

Travel Distance to Providers and Facilities

The second component of the review process tests the percentage of beneficiaries resident in a given county with access to a particular specialty type within the maximum travel distance. For a given county and specialty type, CMS uses the geographic coordinates for the associated providers or facilities and the geographic coordinates for the beneficiaries resident in the county and calculates the travel distance between them. The travel distance is calculated using a formula to determine the estimated driving distance (miles) between the latitude and longitude coordinates and provides an average for the total beneficiaries in the given county

I am currently building workflows on unfamiliar data and using the filter tool on text fields regularly on a large excel file.

As there is no dropdown on the right hand side of the filter tool I find myself needing to open excel and use it's dropdown functionality to find the right text to filter on. I know I could use the summarise tool but each time I run the workflow it takes many seconds to complete before it is populated. It is quicker to use Excel. I am surprised this has not been requested before.

Posting this idea after searching the community postings and then submitting a question to confirm:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Function-to-convert-to-from-HEX-encode...

I could invest the time into creating a macro to do what I need, or per @MichaelF suggestion a custom formula. However, the functionality already exists in the Blob Convert tool, so I'm suggesting that Alteryx provides that existing functionality to customers in a Formula.

I checked the Conversion formulas:

https://help.alteryx.com/2019.1/Reference/Functions.htm

And found other users talking about making a macro to do this:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Hex-to-ASCII-Conversion/m-p/344126

Could Alteryx add a new Conversion formula to convert a field to/from HEX/Base64 formats similar to the current Code Page conversion functions?

Thanks,

Cameron

It is nice that there is a sample node option for In-DB, however it isn't a random sample.  It isn't always feasible for me to stream out and use the random sample % option.  In fact on numerous occasions when I use the Data Stream Out option in DB I often times have workflows crash because it can't handle the number of records I am trying to stream out.

An independent volume control would be helpful when testing workflows and you keep getting errors it can be annoying and distracting to neighbors if they keep hearing the error PING. You may need to keep your master volume up to be able to hear incoming emails, etc.

I have a problem where bulk upload is failing because the last column of the table that the data is being imported into, is using the DEFAULT data type option. I am not passing through any value to this column as I want the DEFAULT value specified to always be applied.

The COPY command fails in this scenario if you don't specify an explicit field list

More details of the problem can be seen in this post, along with a workaround:

http://community.alteryx.com/t5/Data-Sources/import-into-redshift-DEFAULT-data-value/m-p/16655#U1665...

A tick box option should at least be added to the bulk upload tool to enable explicit field list specification based on column names coming into the bulk upload tool

I have a module that queries a large amount of data from Redshift (~40 GB). It appears that the results are stored in memory until the query completes; consequently, my machine, which has 30 GB memory, crashes. This is a shame because Alteryx is good with maintaining memory <-> HDD balance.

Idea: Create a way to offload the query results onto the HDD as they are received.

What if you had the option to connect tools without the lines going across the canvas?
This might be useful in cases where one connection is close but another is far away.
Of course, it would need to be easy to turn these on and off, and to jump from one end to the other.
The idea came up at a SoCal Alteryx users group this summer. Would other people like to see something like this?

I want my Save Setting to stick on the Browse tool when I save output.  I almost always save to Excel.  The default is to save the output as an Alteryx .yxdb.  That is useless unless I going to further slice and dice in Alteryx - which I'm not - which it why it being output to Excel to go to the end user.  Once a file type is chosen - let that file type stick for future exports as most people save there output in the same file type each time.  I find myself inadvertently saving .yxdb and then needing to resave in .xlsx.

For the purpose of debugging a workflow, I often filter just one customerID or any other ID to analyse the workflow.

With the Browse tool (ctrl-shift-B) you can just double click a cell and copy the value of it. This is not possible in the result tool, it would be nice if that would become possible.

Thanks,

Hans

When selecting a colour for a container I would like to be able to click randomize and let Alteryx pick the colour, however I would like the option to click 'random new colour' so it picks a colour not already used in a container on the current workflow  I should then be able to customize the transparency as per normal.

for the past 8 months I have been using alteryx and mostly working with the connect in db components , there are many issues which I am facing and i this this can be improved 

1. there is no such  flexibility of creating a table with the keys defined which is the most important pillar in database, also the options provided are limited , i.e. to create a new table , delete and append, drop table and recreate, 

now, there are many times where in we  need to update the tables based on the keys, which i find missing. Also how the option is defined is create a new table, next time if the job is run it states that the table is already created, for which we need to manually change the option in the next run.

2.which switching between in db and alteryx , if the records are more the alteryx lags completely and the job keeps running for hours , how can we achieve the flexibility  of alteryx designer if there is such bottleneck.

3.the flexibility that is provided with alteryx designer should also be given to in db components.

4.the parameters defined in the workflow can not be accessed in the in db  formula tools but can be used in the designer formula tools. this reduces the flexibility.

please look into the same

how to share Custom Tool Palette (along with Macros) with other users. 

For eg, I have created a custom tool palette named "Adhoc Analysis" with few macros; something like attached.

Now, how to make sure that all my user base can have same palette in their local alteryx designer. 

After some research, I did found that I could share macros with them by putting all relevant macros on Alteryx Server, and users could then pick the macros from there. 

Although, I wanted to suggest this as an Idea for future releases, it would be great to have an option or way, on how to share this with users in their local designer without much hassle.

Not sure, if this is something worth exploring from Alteryx development team side. But thought of suggesting to community if this could help others.   

Thanks for your help. 

Ravi Sharma

Lets say we have data for 3 different regions coming from input file/DB. Asia, LA and EMEA region data are all in one file.

After the transformation, checks which were needed, now I want to output my results per region. 

Due to user access to data, we have designed 3 different folders - one for each region.

So, Asia region output should go to --> ASIA Folder, and similarly for rest of the regions. 

Currently, there is no option to dynamically select and change the output folder path in output tool. 

It would be great to have a way to be able to choose output folder based on a field value.