Alteryx Designer Desktop Ideas

The option to "Allow Shared Write Access" is only available under CSV and HDFS CSV in the Data Input tool. It would be very helpful to have this feature also included for Excel files.

It would be useful to have a function or a tool to convert a number into a currency like excel.  Where it would add the $ before and you could choose to have commas and a period for cents.  

ex:  

Input:  15978423.89

output:  $15,978,423.89

of course, i'm sure there would be a need for other currency values besides the '$'.  

415978423.89

Right now there is not an exception join in DB which means if I want to remove records I have to filter on NULL and with large tables this is really inefficient.

It would be nice to tie the labels to the spatial objects being labeled.

Currently using these macros from Adam Riley: http://www.chaosreignswithin.com/

The stuff he has over there is great and makes alteryx much more powerful.  Two tools in particular that I am using from there are Conditional Runners and the Parallel Block Until Done.  These are tools that for us are vital and it would be nice if Alteryx would pick them up and maintain them for stability.  

I think that it would be nice to be able to append a Time Stamp to the name of a file in the OUTPUT Tool, as a Mainframe Programmer I could append a time stamp to file names this is helpful when doing batch jobs that are scduled on a server. 

It would be extremely useful if most Alteryx tools had the option to output error records seaparetly. This functionality is already present in most other ETL packages, even freeware ones like Pentaho - Kettle. From its wiki: http://wiki.pentaho.com/display/EAI/.09+Transformation+Steps

http://wiki.pentaho.com/display/EAI/.09+Transformation+Steps

Step error handling allows you to configure a step so that instead of halting a transformation when an error occurs, the rows that caused an error are passed to a different step.

Like many of you, I have a lot of modules and macros ... and growing. I keep them fairly organized in different folders and subfolders but sometimes I can't find that particular module I was working on weeks ago.... and I need to get it now. Now I end up doing an advanced search in windows explorer by date and maybe looking for certain keywords.
It would be nice to keep track of them in alteryx - add tags, customer names. depts to modules (meta info tab)?
Maybe a special container/gui with time line would read the meta info tab so you can more easily find that one module/macro

Also, another gui containing tool name tags so you can easily find all module that use that one tool you're looking for

We are seeing a trend where database teams are using certificate authentication with process ids instead of passwords.  It would be extremely beneficial if Alteryx supported this type of authentication so that users can utilize the benefits of process ids instead of their individual ids which require password changes every 45 days.  The database team that is currently switching to this type of authentication is the Mainframe DB2 team but it would be great if Alteryx enabled this for all database platforms.

I often have to process strings as number, i.e. read a number from a csv as a string and then have to convert to number.  I would like to be able to use the data cleanse component and say treat as number format and then select the format, e.g. fixed decimal.  I would then expect the cleanse component to strip out any characters that would prevent the string from converting to the number format, i.e. strip out the commas but leave the full stops.

Hi,

i recently started working on Alteryx and would like to ask if its possible to have preview of data when using In database tools working with db tables.

I have to invest more time on seeing the result using browse tools which again slows bit the performance on queries just to see the results.Also each step you have to add browse tool.

I have worked heavily on powerbi and see this as prime need as in PBI you can work on the visible data itself and figure it out right away how the transformations are working.if preview feature with cache options are given i guess that would be a big booster for Alteryx users.

Thanks,

Brij

Hi,

I've been using desktop scheduler to download and parse out a streaming JSON file.  My script takes 4 seconds to execute, the data is updated on a per second basis.

Currently, my only option is to execute the scheduled job at the lowest level of granularity in the temporal at 1 minute. therefore I'm missing records.

Would it be possible to add a second(s) option to the scheduler?

I can see particular benefits from doing a CRON at under a minute, especially with event data capture.

Best Regards,

Allan 

I would love to see the option to publish the description information from an alteryx workflow into Tableau tde files as the default comment field

Hi, Wanted to see a connector tool for DoubleClick Search similar like Google Analytics and Adobe Connector. This would be a huge reporting benefit for a lot of digital marketing companies - worth putting effort for. Other vendors have done this in the past. 

Dear Dev Team

The ? Help page of macros is by default an Alteryx one (https://help.alteryx.com/11.7/index.htm#cshid=MacroPlugin.htm) : not very informative for a user

Why not changing the default Help landing page and applying rather the macro Description written by the macro developper : it would be far more useful for users

Thanks for reading this idea

Arno

In Table tool column headings using the table and render tools should offer ability to wrap and justify (horizontal and vertical).  right now you can justify a column and the heading may or may not stack (wrap) based on table size and the width configuration in the table tool.  I wish you could give a it more control like we have in Excel, for example left justified and wrap for a column heading with blanks separating words results in auto stacking the words based on column width, auto or manual width control.

It would be immensely helpful if there can be a way to display the 'Manually Configure Fields' section of Union tool to the App user.

Something on the following lines - User uploads few files and then a window opens up onscreen which allows the user to 'manually configure fields' just like it is visible in the Union tool in a workflow. Its best use case is where we have a template with defined headers and the user just need to upload a new file/files and align the incoming fields correctly with the blank fields of a template.

I had an issue with the ARIMA tool using the R function auto.arima() which missed the obvious seasonality in my data set, but when I manually adjusted Model Customization > Customize the parameters used for automatic model creation > The seasonal components > Alter the degree of seasonal differencing and selected 1, the outputs were much better. The problem is that while this fixes my singular ARIMA model, I want to be able to run this through Model Factory too as I have hundreds of data sets on which I'd have to make this adjustment since auto.arima() misses the seasonality on most of them and produces useless results. Apparently I'm not alone in having this issue as I was directed to another comment thread where someone had the same problem and desired fix as me.

TL/DR version -- please make is possible to manually adjust the parameters of the ARIMA Model Factory tool, or at the very least add the option to alter the degree of seasonal differencing.

And for supporting information, here is my thread:

https://community.alteryx.com/t5/Advanced-Analytics/ARIMA-model-missing-seasonality/m-p/87776#M3000

And here is the other thread where a different person had the same issue:

https://community.alteryx.com/t5/Advanced-Analytics/TS-Forecasting/td-p/28857

Ability to run. Workflow from failed tool onwards .

If a workflow has 10 tools , if some tools failed with error(at tool5) , in an etl world we don’t want to run it again from beginning, instead we fix the tool (tool5)that had error and run from that tool and finish workflow .tool 5 to tool10.