Alteryx Designer Ideas

I often have up to ten or more workflows open at a time, several are named and are active workflows that I want to save, and the rest are just scratch workflows where I'm trying something out. When I close Alteryx it asks if I want to save changes to workflows, with the list of all the workflows. If I don't want to save the scratch workflows, I have to cancel, close each one individually, then exit Alteryx again, saving the ones I want to save.

It would be great if there was a check box next to the workflows in the list where you could check the ones you want to save, and it would drop the rest.

Presently when mapping an Excel file to an input tool the tool only recognizes sheets it does not recognize named tables (ranges) as possible inputs. When using PowerBI to read Excel inputs I can select either sheets or named ranges as input. Alteryx input tool should do the same.

In order to debug a call to a REST API - it is often necessary to take the web call, and pop this into a web browser. Can you add a second output to a RestAPI tool (a derivative of the Download tool) that has a second output that provides the full web call that was made, including the full parameterised URL. This would make it MUCH easier to debug rest API calls.

cc: @TashaA

Similar to this idea https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Download-tool-Request-and-Response-details/i...

except my preference would be to pull Rest API calls into a more specific tool and give a second output for the responses

I would like to see a beta testing badge. It would be cool for each version so we can see who is pushing for a better Alteryx future.

This appears to be a bug with either the Layout Tool or the Render Tool. When I setup two Tables using the Horizontal Layout Tool and export to Excel using the Render tool, the font size of the bottom-right cell of the first table is too large. No amount of changing the font properties within the Alteryx Reporting tools appears to fix this.

This should be a simple addition:

In the same way that many default tools automatically generate annotations when they are dropped into the workflow, or their configurations are modified, there should be a way to add custom annotations for custom made macros. 

Thanks!

I'm not sure if this will ever be possible, but I know that it would greatly benefit me and I'm sure thousands of other users. In my work place I am constantly working in a conference room and at my desk. At my desk I am wired into an Ethernet connection while in the conference room I am wireless. When I start my workflows after working with my team in the conference room, I can't go back to my desk until the workflow is finished running because I am changing internet connections and I lose connection to the databases. With the pause button it would become possible to run a workflow and then change my internet without losing connection to the databases.

Another use for this would be while testing a workflow with a new tool. There are times I run a workflow that can take a few hours, but then I realize there is a mistake somewhere in my workflow, where the data hasn't reached yet. I think it would be very helpful to be able to pause the workflow and add the new tool in, while seeing results from tools it has already passed through.

But yet again this is just an idea that relates to me, I wonder what the rest of the community thinks.

I'd like to append a field to an Excel file name in the Output tool but for Excel it appends the field to the Table name instead.

The solution is build the filename ahead of time as mentioned in @HenrietteH 's KB article but that seems less than elegant.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Guide-to-dynamically-renaming-output-...

Solution:

Expand the list of options to:

Append Suffix to FIle Name

Prepend Prefix to File Name

Append Suffix to Table Name

Prepend Prefix to Table Name

Cheers,

Bob

When you right click on a macro, and say Open Macro - it opens up a new copy even if there's an existing copy of exactly the same file open already.

Please can you change this to focus on the existing copy by default?    I've wasted hours editing the wrong one, or doing split editing across two copies of the same file.

In earlier versions the MongoDB Output did not pass fields with null values; this was ideal for storing individual attributes, where one person may have 4 attributes and another may have only 2 attributes, because we did not waste space storing empty or null values.  The newer versions pass these fields with null values; I would like the option to not pass these fields. Please see an example below.  Thank you for your consideration.

Workflow Results

MongoDB Output Current Versions

{"_id" : "1",
"Attribute1" : "A",
"Attribute2" : "B",
"Attribute3" : "C",

"Attribute4" : "D"}

{"_id" : "2",
"Attribute1" : "Z",
"Attribute2" : "Y",
"Attribute3" : null,

"Attribute4" : null}

Desired MongoDB Output (previous functionality)

{"_id" : "1",
"Attribute1" : "A",
"Attribute2" : "B",
"Attribute3" : "C",

"Attribute4" : "D"}

{"_id" : "2",
"Attribute1" : "Z",
"Attribute2" : "Y"}

Is it possible to expand the filter function with an extra option to select a field with a filter definition in it. I want this so i can define a filter over multiple fields an type.

I saw that Carlos has made a similar macro (Click here).

To execute a filter saved in a record set i now have build a macro. this is how my macro looks like. nothing fancy but it does his job. 

the macro is then called like this:

regards Humberto

US and Canada datasets are underlined so far but,

Alteryx is expanding towards, Denmark, Germany, France and several other countries...

The question is; Why don't we have Eurostat data provided as well?

Bulk options for some datasets are available.

Even one can get a grasp on micro datasets and Alteryx may have a deal inf this micro dataset is anonymized...

Not sure if this has been submitted... or if this option is already in a newer version.

There should be an option, after correcting an issue/error within a workflow for users to start again at the error point instead of running the entire workflow again.

This option will help users to streamline the process of building workflows and avoid wasted time spent waiting for large complex workflows to complete or error out.    

With the amount of users that use the publish to tableau server macros to automate workflows into Tableau, I think its about time we had a native tool that publishes to Tableau instead of the rather painful exercise of figuring out which version of the macro we are using and what version of Tableau Server we are publishing to. The current process is not efficient and frustrating when the server changes on both the Tableau and Alteryx side.

Ok Alteryx, we totally love your product.  And I've got a super quick fix for you.  Why on earth would you Autocomplete the ubiquitous tick mark as "ReadRegistryString(Key, ValueName, DefaultValue='')"

?

I find myself in this situation constantly where, 'dummy' suddenly becomes 'dummyReadRegistryString('HKEY_LOCAL_MACHINE\SOFTWARE\SRC\Alteryx\4.1', 'InstallDir')' the moment I strike the enter key.  

Pls help, I don't ask for much.

This is not a new idea but an old one. It is an elementary requirement which everyone talks about since 2013 and still ignored.

Can we get CONTROL OF EXECUTION OF THE FLOW OR at least EXECUTION OF CONTAINERS ASAP??!!

I have a requirement here in Macquaire but had to give them a workaround as this basic functionality is still missing

Please action

Cheers

Paolo Bottiglione

From Wikipedia :

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object. This pre-established query command is kept in the database dictionary. Unlike ordinary base tables in a relational database, a view does not form part of the physical schema: as a result set, it is a virtual table computed or collated dynamically from data in the database when access to that view is requested. Changes applied to the data in a relevant underlying table are reflected in the data shown in subsequent invocations of the view. In some NoSQL databases, views are the only way to query data.

Views can provide advantages over tables:

    Views can represent a subset of the data contained in a table. Consequently, a view can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view, while denied access to the rest of the base table.
    Views can join and simplify multiple tables into a single virtual table.
    Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data.
    Views can hide the complexity of data. For example, a view could appear as Sales2000 or Sales2001, transparently partitioning the actual underlying table.
    Views take very little space to store; the database contains only the definition of a view, not a copy of all the data that it presents.
    Depending on the SQL engine used, views can provide extra security.

I would like to create a view instead of a table.

Recently we had a situation where installing the data packages was expected to take over 20 hours!  We do not have the ability to run a machine undisturbed for this length of time at the office, and VPN automatically times out after 12 hours.  Okay, so these items are company-specific, but how nice would it be to be able to download/install the data in smaller portions so you don't have to worry about setting up shop for 8-10 hours?!

I was able to copy the DataInstall.ini and name only the portions of the data I wanted to install in each session.  But then I had to separate the installs into different network folders otherwise you end up overwriting the DataInstall.exe file, which users need for each install in order to register from a network location (for each install).

Needless to say, it took SEVERAL weekends and quite a few mistakes before I was able to do it this way successfully!

Please vote for data installs in smaller portions!

Please support GZIP files in input tool in Server. This is related to https://community.alteryx.com/t5/Alteryx-Product-Ideas/Support-for-GZIP-gz-compressed-files-in-input..., but logged in a separate Idea because the staff indicated in the thread that they are planning support for GZIP in Designer only in 2018.2. We need it in Server as well.