Alteryx Designer Desktop Ideas

It was possible to read and write .gml (geography markup language) files in Alteryx. From 2018.2 and up, only write is supported. I do not understand why such a feature was removed, considering that this has become one of the standard geoformats. Joining data from .gml and .shp files is one of the key activities when dealing with geodata. Now I have to spend time converting the files (e.g. in QGIS or ArcGis). FME can read/write .gml just fine, so why can't Alteryx?

I would like to have feature to disable the fitter tool so that all the filters added within the filter tool are ignored when the filter tool is disabled and data flows through to the next tool . At this moment there is no way we can achieve this as adding a tool to a container and disabling it stops the data flow to the next tool.

The Select tool already has some really useful column rename options like add & remove prefix.  Please add uppercase & title case to these options.  I know I could do this with the Dynamic Rename Tool, but this will involve adding two tools if I'm already doing other select type options like removing fields.  Anyway, I'm assuming this would be an easy add for the DEV team and would make my life a little easier! 

Many thanks!

Hello,

It would be helpful if some of your tools had an optional input.  For example, the directory tool is of course very helpful at the beginning of a workflow, however I have several workflows that create or pull in files, rename them, edit them, etc.  I then need the directory tool to check that folder for the newly created files and then to feed that downstream.  The problem is that when I have the directory tool feeding into the workflow, it fires immediately noting that no files are in the folder.  I would love if the tool had an optional input so you could choose to put it in the middle of a workflow in an attempt to force it to hold off on firing until its turn.

Even better would be if the dynamic directory tool would allow for dynamic folders to be fed in rather than pinpointing a specific file....since it has an input, that would suffice and the user could either pick the regular directory or the dynamic directory if they wanted it to fire off in the middle of a workflow.

Hi Alteryx,

Today, Alteryx is can connect to AWS Aurora DB, but it is only for MySQL.

How about AWS Aurora PostgreSQL ? Will it be included in the next release ?

Best Regrads,

Samuel

I like how the Multi-Row and Multi-Field tools have a variable tab to help the user know the proper syntax for building their formulas such as Row-1, Row+0, and Row+1.  That said, it would be nice if the user could change the Expression manually to point to different rows.  You don't necessarily need all of these variables listed, but if the user could change to [Row-2:Fieldname] so that the formula could look two or more rows up/down.  I have a report where I want to divide one row up by the value two rows up.  I have to use a workaround where this would make it much easier.

Additionally, it would be nice if the Multi-Field tool could accept Multi-Row functions mixed with the Current Field function... such as [Row-1:_CurrentField_]

I understand these are two requests, but the ask is similar...simply that the syntax is understood in both and more versatile.

Background:

Teradata is a high performance database system.  It is highly sensitive to indexes and balancing the records across each index segment.

Teradata uses Spool to perform queries on the database.  It is also very sensitive to type of table (volatile, temp, permanent) created.

Issue:

Alteryx "In - Database" nodes are not providing the ability to configure them to Teradata needs.

As a result, when executing workflows with "In - Database" nodes there is high probability of "out of spool" error specially when working on medium size data base (between 250 million to 1 billion records).

Impact:

Question mark on the ability of Alteryx to handle medium to large databases.

Knime and SSIS are currently preferred to Alteryx

Action Requested

Please change the configuration of the "In - Database" nodes to allow fine tuning of the node behaviour.

Hey everyone,

I'd like to suggest making use of Windows Taskbar progress feature to highlight running workflow status, it would be helpful for when you start a workflow and continue working on another application.

I made a workaround tool I append at the end of my workflows alongside with output tools to do the same thing, having the feature natively in the designer would be better.

the tool doesn't take care of other running workflows or different alteryx windows, it can't detect warnings and errors from other tools, although Alteryx Engine API might be better for this implementation, a quick python one is done for demo purposes.

Attached are the tool and a test workflow to demonstrate the feature, all the best.

I'm on 2018.2.

When I click on existing Comment Boxes out in the Workflow I'd like to be able to tack on additional information within the Comment box.

If I hit Enter, I'm not able to type anything in the Comment Box.  I think Enter is taking me out of the Box.  If I hit the space bar, I'm able to type - but a lot of times I'm updating info and I want to start it on a new line.

Yes, I know it works fine in the Configuration Window.

Can we make the actual Comment Box work like the Text Window in Configuration?

Do we have a capability to read number or may be text for that purpose from a PDF format file as an input to Designer Tool we have a system which actually produces a PDF report and then we manually have to segregate the issues according to the categories. Can some one please suggest if there is a solution existing or in working stage

I have a 3 year license but am required to activate the license key each year. Is it possible to get the activation period matched to the duration of the purchased license? This would not only remove the need to update each year, but would also clarify the actual duration of the licence too.

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. 

In 2018.4, in the Select tool we were able to select the attributes, and then with CTRL+C copy these lines to the clipboard.

You could then paste it for instance to Excel. I used a lot this feature to communicate with third parties, to who I provide data.

When I perform an average aggregation the data type changes to increase the precision.  While I could see this is useful sometimes, it is not when I have a currency based field and I want to keep the precision fixed at two decimal places.  The result is I have to either add another select tool to update the data type or find an embedded select in a tool that exists post summarizing.

As reported in this post, I would suggest to only add new browse tools to outputs that do not have a browse tool attached already when using the "Add All Browse" feature.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Undesired-behavior-using-the-quot-Add-...

Thank you!

I built some workflows which will input full or sample data in multiple Input Data tools based on changing the value of a user constant. These workflows have email events enabled after run.I want to change the email subject based on whether the workflow ran in full or sample mode. That's my use case. I know that I could do this using the Email tool and that's not going to work in my use case. If the workflow fails, there won't be an email. Also, I don't know if the Email tool is blocked by just my Gallery or by all Galleries.

To generalise this, I want to dynamically change email event subjects, bodies, and more by either using expressions/constants from the workflow or by having an expression editor directly in the event itself.

Thank you.

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 

Within the fuzzy match tool, it would be great to see a pre-configured match style to help with matching e-mail addresses. I understand it may be possible to configure something manually but as a newbie to the tool who relies on the pre-configured styles I think this would be a great feature.

An extra feature could be a table to match domains such as .gmail.com and .googlemail.co.uk, maybe similarly to the Names / Nicknames table.

Need a Tool in Alteryx Designer which can Route the data on different flow based on certain conditions.

Right now we can do it through Filter tool but it will only two flow. But through Router we can branch out as many as flow we wanted based on multiple conditions.