Alteryx Designer Desktop Ideas

Add extra capabilities int he Output Tool so that the following can be accomplished without the need for using Post SQL processing:

- Create a new SQL View

- Assign a Unique Index key to a table

Having these capabilities directly available in the tools would greatly increase the usability and reduce the workload required to build routines and databases.

Hi,

I am sure that I can't be the only person that would be interested in an output tool that allows categorical fields on both axes.  THis would allow you to visualise the following example and I would suggest that this was either similar to the heatmap with boxes or the colour / size of the entry was determined by a third numerical value - such as 'Confidence' from the table below.  THere might be ways to extend the idea as well as having a fourth parameter that puts text in the box or another number but it would be useful and not too hard I am sure.

Many thanks in advance for considering this,

Peter

I run into this a bunch.  There are some Alteryx workarounds for some use cases but not all.

Hi,

Is there an easy way through Alteryx to rename a file once I have processed it... Would like file name to be- FileName.csv.Date.Time (FileName.txt.20180424.055230)

Thanks.

I would like to able to limit the data being read from the source based on the volume , such as 10GB or 5 GB etc. This will help in case of POC's where we can process portion of the dataset and not the entire dataset. This will have many different used cases as well.

Dear Team

If we are having a heavy Workflow in development phase, consider that we are in the last section of development. Every time when we run the workflow it starts running from the Input Tool. Rather we can have a checkpoint tool where in the data flow will be fixed until the check point and running my work flow will start from that specific check point input.

This reduces my Development time a lot. Please advice on the same.

Thanks in advance.

Regards,
Gowtham Raja S

+91 9787585961 

I've used tools like BRIO/Hyperion with a wide-range of control over the output to MS Excel. The Jooleobject allowed me to control MS Outlook, Excel, Word, etc..  The goal is to run a scheduler within Alteryx every week to blend data, insert the data into pre-formatted and renamed excel templates, copy those files to a network shared drive and finally send a formatted email to my users. If I can get past copy/paste routines, my job would be much more efficient. Thx

Hi,

In the Input tool, it would be useful to have the Saved Database Connections options higher in the menu, not last. Most users I know frequently use this drop down, and I find myself always grabbing the Other Databases options instead as it expands before my mouse gets down to the next one. I would vote to have it directly after File..., that way the top two options are available, either desktop data or "your" server data. To me, all the other options are one offs on a come by come basis, don't need to be above things that are used with a lot more frequency. Just two cents from a long time user...love the product either way!

Thanks!!

Eli Brooks

Many tab files lately (I am finding when they are created in mapinfo 16) Alteryx cannot read.  I have posted about this in other forums but wanted to bring it up on the product ideas section as well.

When using an SQLite database file as an input, please provide the option to Cache Data as is available when opening an ODBC database.  Currently, every time the input tool is selected, it takes an inordinate amount of time for Alteryx to become responsive; especially if the query is complex.  SQLite is not a multi user database and is locked when accessed so there is no need to continuously poll it for up-to-date values.  Pulling data when run or if F5/Refresh is pressed would be sufficient.

The issue may be more primitive than what is solved by having a Cache Data option.  I am more concerned that the embedded query seems to be "checked" or "ran" every time the tool is selected.  I think this issue was resolved with other file formats but SQLite was overlooked.

One of my favorite features of Alteryx is the in-line browse in the results window, as well as the descriptive log, highlighting record counts into and out of tools.  As I develop bigger and longer-running workflows, I would love to be able to save off these results to provide my QA analyst with a "cached" version of a run without them having to run it themselves.  Providing them not only with a well-documented workflow, but with a complete data flow would be tremendously helpful in getting work checked.  Our current process is to pass workflows off, and encourage the QA analyst to run them with the "Disable all Tools that write Output" option checked.  While this is not an issue for smaller workflows, it is inefficient for larger ones, and also can cause some difficulties with access logistics like missing or inconsistent connection aliases.

I have seen some requests asking for saving of browse results (https://community.alteryx.com/t5/Alteryx-Product-Ideas/Save-Browse-Results-Until-Next-Run/idi-p/1827), but these primarily seem to be geared at data caching for further workflow development.  My aim is to save the browse and results statuses of a completed workflow for the purpose of QA.

Note: I posed this as a question in the Data Preparation and Blending forum, but didn't receive an answer so thought I would propose it as an idea.

It would be great if the deselecting of fields in a select tool updated the output window(before next run) as a "review" to make sure you are removing what you expect and/or you can see other items left behind that should be removed. This would also be useful for seeing field names update as  you organize and rename.

Often I join tables w/o pre-selecting the exact fields i want to pass and so I clean up at the end of the join. I know this is not the best way but a lot of times i need something downstream and have to basically walk through the whole process to move the data along.

As recommended by HenrietteH at Alteryx to submit as a suggested future enhancement.

I have Oracle 11 and Oracle 12 clients on my machine. With Toad, I can toggle between either client's current home, but it appears that is not a feature in Alteryx. So now I am unable to execute ETL jobs off my machine or server because Alteryx gets confused. Currently, the only remedy I can think of is having 11 client uninstalled, which can cause dependency issues if I need it in the future.

This may be too much of an edge case...

I would like to be able to feed a dynamic input component with a input file and a format template file, so make the input component completely dynamic.  This is because I have excel spreadsheets that I want to download, read and process hourly throughout the day.  Every 4 hours another 4 columns are added to the spreadsheet, thereby changing the format of the spreadsheet.  This then causes the dynamic input component to error because the input file does not match the static format template.  I would be happy to store the 6 static templates, but feed these into to the dynamic input with the matching input file, thus making the component entirely dynamic.  Does this make sense???

BTW, my workaround was to define six dynamic inputs, filter on the file type, then union the results:

Hi All,

I had posted in the Tool Master | Unique thread about how when I use this tool it does not preserve my sort.

This seems odd to me. I understand that it's "a blocking tool and that records are then sorted prior to executing the tool process" as @TaraM points out. However, in a program where data is explicitly manipulated to a condition, there is an expectation on my side (maybe mistakenly?) that if I sort something that it would not be changed unless stated or indicated in some fashion. 

For my use case I was sorting to eliminate the duplicates, then joining that data to eliminate other duplicates and outputting the resultant to my users and future-state will be automatically fed into a system, for each stage it matters that the sort function is kept intact.

I know it's a simple complaint / fix, but its unexpected behavior on my end and could mean less confusion and less tools on the board. which is always a good thing in my book.

I would like to see the pencil (that means writing to a record) go away when the Apply/Check button is clicked.

Add input of ArcGrid file format.

Slightly off the track, but definitely needed...

I'd like like to propose a novel browsing.

With this new feature you may no longer require the traditional Browse Tool, to the extent that it may be decommissioned later. Here's how new Browse would work.

So far Browse Tool is helpful for mid-stream data sanity check...

But a complex workflow will need so many Browse Tools, thereby wasting a lot of canvas space and unnecessarily complicating / slowing the workflow further.

Expected Browse:

Clicking on any tool should automatically populate its results in the Results window without the need of Browse Tool.

1) Tools with a single output: Clicking on the tool or its output plug should reveal its data (ex: Summarize Tool)

2) Tools with more than one output: Clicking on each of the output plug should reveal its data (ex: Join)

BONUS: Clicking on the input plug of a tool should reveal its input data

Imagine We have following o/p fields like Name,RegNo,Mark1,Mark2 ,total

Here total can be computed and can be brought as derived field using formula tool.

However  Name and RegNo will be the same in O/p too.

• Instead of Mapping Manually mapping Output_Name to Input_Name, A smart Mapping feature can be introduced so that it can automatically map based on name of the columns.
• Once smart mapping is done,Developer can review and make changes if needed.
• This will reduce the manual intervention of selecting from existing fields.
• Will be helpful when we process 100s of Input data into Output report.

Thanks,

Krishna