Alteryx Designer Desktop Ideas

Right now we can only change the alteryx log folder but not the log file name. If we can change the log file name , it will be great because that gives us the ability to parse certain logs and check for errors/issues and send out emails accordingly.

It would be nice to have the option of reassigning the Tool ID's based on each tool's process order within the workflow.

Hello,

I work with alteryx databases a lot to store some historical data so I don't have to pull it in the future. It would be great if there was a way when creating the database, where I could lock them for editing and can only be edited by select usernames and passwords.

Thanks,

Chris

Looking forward for the addition of in-database tools for SybaseIQ or SAP IQ

Please star that idea so Alteryx product management can prioritize this request accordingly...

Note on SAPIQ;

• SAP IQ is a database server optimized for analytics/BI, it is a columnar RDBMS optimized for Big Data analytics
• IQ is very good for ad-hoc queries that would be difficult to optimize in a legacy transactional RDBMS...
• It's ranked number 48th amongst all DBMS and 27th amongst relational DBMS
• SAP IQ16 has gained R language support

currently we can connect with ODBC, http://community.alteryx.com/t5/Data-Sources/sap-sybase-iq-ODBC/m-p/9716/highlight/true#M700

I would like to see either the option to create a Venn Diaram within the current chart tool or an entirely new tool specifically for Venn Diagrams.

I often work with data from multiple sources and would like to better understand how much of my data is in multiple sources and how much is only from a single source. A great way to view this is with a Venn Diagram.

Please add the ability to interface with Oracle Siebel CRM. Preferably, this would be a built-in connector similiar to the SFDC Connector.

Hi All,

I think it would be good to have the ability to pick a connection and drag and reconnect that to another tool.

Following are some of the areas where it might come handy

1) In case a tool is there which is having good number of connections and we want to move all connections to a new tool.
In current scenario, I end up deleting my existing connections and then re-establishing those to the new tool.

2) In case there is an existing connection which is separated by a good distance on the canvas and we need to move one side of the connection to a tool near to the existing tool.

At the moment, I am making use of select tool to save me some effort for above cases, in case of scenarios calling for reconnection, I generally put a dummy select tool and reconnect existing connections to select and then delete the existing connection from tool(to select tool) and repoint connection from new tool to the select.

Thanks,
Rohit

Please include IBM DB2 as an in-Database option. Currently, my primary use of Alteryx is for copying DB2 tables into Teradata for use on that server. Copying large tables and particularly joining several tables and copying the results to Teradata is too slow in Alteryx.

I find this page very helpful to understand how each tool works:  Alteryx Tools

It would be really great if Alteryx also provides a working example for each tool. For an effective hands-on experience....!!

Hello,

I work for a company with circa 250K employees. We are in the process of shifting all documents over to OneDrive and I've noticed that when I have an Alteryx workflow that uses inputs stored on OneDrive the connection can be very intermittent. I use the UNC file naming protocol for my input/directory tools, but more often than not I need to run a VBA script that accesses OneDrive before Alteryx tools will connect.

There's a couple of posts on this community about this, but nothing in the ideas board. I believe the SharePoint connector is being updated for v11, but nothing for OneDrive.

I'd like there to be better integration to OneDrive for business and SharePoint Online please.

Thanks,

John.

I think it should be done ASAP.

Hope this is fairly self-explanatory.

I'd like to be able to create presets for Summarize tool.  Instead of having Group By, Sum, Count, Count Non Null, etc on top of the libraries of functions, put them into their own category.  Users could then create a Favorites and the functions that they use the most would be stored in that section (editable by user).

Hi All,

I believe the following would help improve the functionality of Select Tool.

The idea is to have a defaulting option for each of the field in the Select Tool (which I believe should be a light weight Tool i.e. not adversely impacting performance and gives best exhaustive picture of all columns flowing through a (/particular point in ) pipeline).

Following are some of the cases where defaulting might come handy -

1) Fields which are supposed to hold monetary data - instead of Null, one can put 0.00 to help roll up summary properly.
2) Fields which are supposed to hold dates (say expiry date) - instead of Null, one can put some enterprise standards like 31-12-2099 to avoid mixing Nulls and 31-12-2099.
3) Fields which are supposed to hold purchase quantity/number of employees/number of merchandise - instead of Null, one can put 0 (and not 0.00) again to help with roll up summary.
4) Fields which are supposed to hold Currency - instead of Null, one can put USD.
5) Fields which are supposed to hold dates (say this time create date) - instead of Null, one can hardcode actual date, or an additional feature to put Now() kind of functions.

At present one of the options of achieving same might be to put a Formula Tool and to code whatever is desired inside the Formula Tool.

Benefits of having the functionality inside Select Tool would be -

1) It would be more user friendly and call for faster build to just write '0.00' or 'USD' or '31-12-2099' as compared to writing IF IsNull()... statements.
2) Inside Formula Tool, user needs to pull desired fields from the drop down and hence exhaustive view of all fields passing through pipeline is not available.

Pain in selection of fields from drop down and writing actual formulas might be aggravated with the number of columns increasing and might be more prone to human omission related errors.

Thanks,
Rohit Bajaj

Please add a configuration to the RedShift bulk load to EITHER use access keys or an IAM EC2 role for access. 

We should not have to specify access keys when we are in an IAM enabled environment.

Thanks

Teradata has a feature called query banding where a group of queries or more commonly a database session can have additional metadata tagged onto all of the individual queries. The Teradata workload management engine can use information provided in the query band for use in prioritizing query execution and resource allocation.

With normal input tools, the query band information can be populated in the "Pre-SQL" with a query such as:

SET QUERY_BAND = 'org=Finance;report=Fin123;' FOR SESSION;

However, with the In-DB tools, there is no concept of pre-SQL, and no great way to set the query band for the In-DB queries Alteryx submits. We would want to set the query band at the workflow level for performance prioritization and resource allocation monitoring purposes. 

Best regards,
Ryan

During the design phase, we make some experimentations and create tables with Alteryx.

But, sometimes, after this phase or after a mistake, we need to drop those tables.

We know that it's possible to write a drop table statement in Pre-SQL or Post-SQL but it requires SQL skills and it could be done only if you write in a table.

It will be great if we could drop a table directly in the Query builder of the Input tool by making a right click on the table in the discovery tree.

Extension : It also be great to have the same thing in the HDFS browse.

My users need the same functionnality In-db as the in-memory tool "Field Summary".

The purpose is to discover the data : distribution, minimum, maximum, count,valid, unique, ...

In the in-db join, add the possibility to make left-except or right-except join in addition to the 4 available options.

A function to generate relevant Random Mockup data to replace existing data or create new test data sets.

Insert into fields mock data for First Name, Family Name, Email Address, Country, Regular Address, Payment amount and information, etc.

This would be easy to code and could be used to easily replace existing fields with made up fields or jumbled up fields or numbers e.g. payment amounts randomised to a similar size and shape.  There are a number of internet sites that already provide this service but it would be so much better to bake this directly into a tool that allows you to generate random datasets for testing and anonymisation of existing data for demos etc.

This would make users of Alteryx much more productive and allow them to preempt datasets and allow much more rapid creation of solutions.