Alteryx Designer Desktop Ideas

At the moment, we are not able to use input data field names and its values in Output tool, mainly in the Pre-SQL and Post-SQL statement. I see some discussions on this in the community and in many scenarios we require that. It will be great if we have this option.

I think it would be great to add metadata to a yxdb. For example, I was back tracking and trying to figure out which module/app I used to create an old yxdb. Now I use Notepad++ and do a "Find In Files" Search. Wouldn't it be great it the module path would be available when you look at the properties of a yxdb in Alteryx?

I have several .yxdb files that I’ve been appending to daily from a SQL Server table in order to extend the length of time that data is retained.

They’re massive tables, but I may only need one or two rows. 

I had hoped to decrease the time it takes to get data from them by running a query on them (or a dynamic query/input) as opposed to using a filter or joining on an existing data set which would have equal values that would produce the same result as a filter.

Essentially, the input of .yxdb would have the option of inputting the full table or a SQL query just like a data connection.

I run a report generator that can leave you with having to save one at a time several files.

It would be nice to be able to save multiple files at once.  Whether using a check box or a shift select method.  If this method already exists, Great!  Where can I find out how to do it.  If not can it be an added feature?

Its definately not a good UX that the full browse is now in the output window.  I usually have my Output on autohide and its a few extra clicks to see the browses now... Can we have both the Browse Everywhere tab in Output and Configuration Panel?

I was recently surprised to find that Alteryx doesn't already havea connector to upload to SFTP sites.  I've managed to work around it with RunCommand and some external programs, but it's very cumbersome.  A simple SFTP upload connector would be a great addition to Alteryx.

At TargetSmart, we create a lot of CSV deliverables for our customers. Since Alteryx differentiates between blank strings and null values (a good thing), the CSV output is not consistent between the two without an explicit multi-field formula step to set all null to empty strings (or vice versa). This is an easy fix for us. However, in some cases we have very large files with thousands of fields and millions of records. For these instances, the workflow run-time is greatly increased by the multi-field formula. If possible, I was wondering if adding a checkbox option to CSV output steps (“Make null/empty consistent” or “Never quote empty/null values”) would possibly be a more efficient approach as the check could be part of the output step (which I assume is native C++) versus the Multi-field formula (which I assume has some level of inefficiency in interpreting the formula dynamically).

I know you can add a field for "today" and then use that field to append the filename, so the output ends up as Ouput_Date.xlsx, but it would be great to be able to do that without adding a new field for the current date. If it were simply an option in the filt output settings dialog, that would be great.

The capability to input/output R Datasets via the input/output tools, together with all the other data formats as well (like csv, Excel, SAS, SPSS, etc).

Would be great if we could right click on an input and in addition to having "convert to macro input" there was an option for "convert to dynamic input".

Greenplum / Postgresql Bulk Loader Capability much like the oracle and MS Sql.

Thanks!
John

default file path in "File Browser" interface app would be a nice to have feature. Similar to what we have in Numeric, Text etc. interface app.

Hi Alteryx Team,

My work is to create Output from Alteryx and upload the Output file into Tibco Spotfire. So i want a system in which Alteryx output directly goes in to the Tibco Spotfire and update Tibco Spotfire in every 6 hours.
So do you have any plan to connect the Alteryx with Tibco Spotfire? This is will help me to automate the project.
If not pls think on these concept for future use.

Dear Alteryx Team,

Dynamic Input Tool is a great tool to import easily multiple files using files paths parameters ... having the same tool for outputs would be great to export many files in pre-established folder.

Many thanks

Arno

We have several .txt input files (same structure) that need to be combined into one file.  But all the files have summary information on the first 6 rows.  Alteryx help me created a macro to skip the first x rows but it is involved - but it works.  Having a "start data import on line x" would greatly simplify the process.

When I setup an In-DB connection I need a way to select only the tables I want to see. Basically a way to favorite the most frequenently used tables and also the ability to add a description of the information that resides in that table. Use Case: Because we have so many irrelevant tables with no data dictionary in some of our databases this would save a ton of time to narrow down the tables I can select right off the bat.

One of those small little annoyances that can add some extra time to development is how when you browse for a file (either with the Input Tool or Output Tool) it always defaults to the most recent location of where you either picked up a file or output a file.

Many times I have existing Input Tools or Output Tools that I simply need to repoint (meaning they already have a file location mapped to either read or write to.)  For these, it would be great if, when the user clicked to File Browse, the initial folder location displayed was the same folder where the current file is mapped to. 

Perhaps displaying the most recent folder in the file browse interface may be best suited for when a file has not been mapped yet.

We would like to have the ability to overwrite sheets in macro-enabled Excel workbooks.  Several of our scorecarding templates leverage macros for Excel events, protection, and interaction, and the ability to directly overwrite data in these workbooks would be a huge benefit of  using Alteryx.

Pretty simple but could be helpful when troubleshooting and reviewing.  Allow a user to have rows be banded in a different color, allow the user to select how to do the grouping to band.  For example, a large browse tool has several thousand rows, sorted by product name.  Each product has between 5 and 50 rows each.  If a user could set color banding by product,.. they could easily find the "breaks" between product rows.  This could be somewhat similar to the Excel table formatting option for banded rows,.. you could simply alternate bands,.. but would be nice to be able to group the bands by some column attribute in the data.

This may be a little easier than constantly opening new browse windows with the selected records,. or to use filters or other tools to group the data for review / troubleshoooting purposes.