Alteryx Designer Desktop Ideas

Following unexpected behaviour from the Render tool where outputting to a UNC Path (see post) in a Gallery Appliction, on advice of support raising this idea to introduce consistent behavior across all tools where utilising a UNC Path.

You can select all fields at once, but it'd be nice to select a chunk of fields using CTL+Shift+Click

Since we use Mosaic extensively we would like for the colors used in the Interactive Chart tool to be assigned by a value in order to match Experian's color assignments.  For example, if [Mosaic] = “A01” then use RGB 77/72/ 133.

 

Thanks for the consideration.

When checking the 'Disable All Tools that Write Output' option in Workflow Runtime Configuration, I would expect that In-Database Tools that wirte records to a database should be disabled in addition to standard in-memory output tools.

 

"Data Stream In" and "Write Data In-DB" immediately come to mind, but there may be others:

 

May I suggest that you include a facility to word wrap the cell viewer in a browse. When working with long OuterXML strings, for example, it would be very useful to see the full extent of the string. 

 

Thank you

Request is to add in the parameter to control sampling level in the Google API connector. I'm getting very different results pulling the same report from the API and the GA UI. The API data has significantly more variability which is evidence of sampling. We have a premium 360 account and are still getting the sampling results, I believe its just necessary to add in the parameter in the outgoing script providing: 

 

samplingLevel= DEFAULT, FASTER, or HIGHER_PRECISION.

 

https://developers.google.com/analytics/devguides/reporting/core/v3/reference#sampling 

https://developers.google.com/analytics/devguides/reporting/core/v3/reference#samplingLevel

 

- Zach

For an email event, there are several defaults that are shown in the body (e.g., %User%, %ComputerName%, %WorkingDir%).

It would be nice to add a date in there, maybe %Date% or %DateTime% or something like that which would display the computer system time.

Would save an extra select for parsing text files in correct format for dates and times.

 

 

Hi , Currently we have 3 methods to calculate distance.  K-means, K-median and Neural gas. Can we also include DBSCAN (Density based spatial clustering) as one of the method. I can colloborate with product owners of alteryx to make this happen. Please let me know.

Using the download tool is great and easy to use. However, if there was a connection problem with a request the workflow errors out. Having an option to not error out, ability to skip failed records, and retrying records that failed would be A LIFE CHANGER. Currently I have been using a Python tool to create multi-threaded requests and is proven to be time consuming.

Similar to the post from @MarqueeCrew here: https://community.alteryx.com/t5/Alteryx-Product-Ideas/In-Database-Update-and-or-Delete/idc-p/72744#..., there is a need to increase the ETL functionality of Alteryx to allow this to serve the needs of an enterprise BI audience.

 

Specifically: 

- Bulk file sync.   Similar to SSIS, the abilty to very quickly bring a file in a staging area up-to-date with the latest in the source

- Dimension update.  Built in macros to make dimension update (especially for slowly changing dimensions) easier - these would take care of the various time-dimensions, and checking for surrogate keys - and also add in translation tables

- Central registry: register a central list of shared dimensions, shared fact tables, etc

- Symantic layer: where several teams use different identifiers for a particular concept, such as customer.   By marking a particlar field as "Customer", the Alteryx engine can make more intelligent decisions about how to normalise these to a confirming dimension

- Simpler logging of ETL errors (similar to the ETL logging recommended by Kimball)

 

A focus on large-scale BI & ETL applications like this will really help to allow Alteryx to bridge from point solutions to a broader spectrum of opportunities in large-scale enterprise BI.

 

 

I'd like to see the DateTimeLastOfMonth and DateTimeFirstOfMonth functions be more flexible then just getting the first or last date of the current month. It would be great if you could point to a date field and have it give the first or last date of that month. i.e  DateTimeLastOfMonth([randomdate]) and if the [randomdate] = December 3rd, 1981, the result would bring back 1981-12-31

The current SharePoint API pull tool does not support the pull of managed metadata columns. It would be great if Alteryx would update the SharePoint List tools to be able to read in managed metadata columns.  

 

I'm sure no one want's to do double dipping on huge data sets even if it's in-db...

So can we have,left and right joins in the in-db join tool as well to further develop workflows from these two additional outputs?

Ps: the idea originally belongs to another Alteryx client mentioned this in IT central; https://www.itcentralstation.com/product_reviews/alteryx-review-38876-by-prometheus-tito-amoguis-ii

 

Best

I am trying to schedule something to run every 2nd workday of the month (which will not be the 2nd day of the month every single month because the first day of the month might land on a Friday which would make the second workday the 4th of the month). Is there a way to implement this in a schedule? 

 

For a few months we have used the custom schedule since we know the specific dates they would land on but it doesn't seem like the most efficient.

 

Thanks for you help. 

 

 

Wild card read option (Sales_*.csv ) works for reading files of the same structure available on a standard windows network/local fileshare. It would be good to have the same feature for reading from HDFS via the HDFS connection option using the input tool.

 

 

 

Regards,

Sandeep.

 

Think of a pivot table on steroids. In my industry, "strats" are commonly used to summarize pools of investment assets. You may have several commonly used columns that are a mix of sums and weighted averages, capable of having filtering applied to each column. So you may see an output like this:

 

Loan Status	Total Balance	% of Balance	% of Balance (in Southwest Region)	Loan to Value Ratio (WA)	Curr Rate (WA)	FICO (WA)	Mths Delinquent (WA)
Current	$9,000,000	90	80	85	4.5	720	0
Delinquent	$1,000,000	10	100	95	5.5	620	4
Total	$10,000,000	100	90	86	4.6	710	0.4

 

Right now, I feel like to create the several sums and weighted averages, it's just too inefficient to create all the different modules, link them all together and run them through a transpose and/or cross tab. And to create a summary report where I may have 15 different categories outside of Loan Status, I'd have to replicate that process with those modules 15 times.

 

Currently, I have a different piece of software where I can simply write out sum and WA calcs for each column, save that column list (with accompanying calcs) and then simply plug in a new leftmost category for each piece of data I'm looking at. And I get the Total row as well auto-calculated as well. 

Hello,

It would be great if there was an option to compute 'median' on numerical data column in 'cross-tab' tool. We trust 'median' a lot more than 'average' in many different computations.
I would stretch my suggestion far enough to propose adding quantile computations as well...

Thanks!

I would like to see a Full Screen View under View on the Menu Bar.  Once selected your workflow would show full screen with out all the other side and bottom windows.  You could leave just the Menu bar showing so the workflow could be ran.  This would be nice for presenting/teaching.  Also, maybe have it default to cntrl 0 so the entire workflow is showing.  Zooming in and out could still be done.  Then to Exit. Go back to View and uncheck Full Screen.  This would be easy and, I think, helpful.