Alteryx Designer Desktop Ideas

Please support GZIP files in the input tool for both Designer and Server.

I get several large .gz files every day containing our streaming server logs. I need to parse and import these using Alteryx (we currently use Sawmill). Extracting each of these files would take a huge amount of space and time.

This was previously requested and marked as "now available", but what is available only addressed a small part of the request. First, that request was for both ZIP and GZIP. What is now available is only ZIP. Second, it requested both input and output, what is now available is input only. Third, while not explicitly stated in the request, it needs to function in Alteryx Server in order to be scheduled on a daily basis.

Hello,

As of today, we can't choose exactly the file format for Hadoop when writing/creating a table. There are several file format, each wih its specificity.

Therefore I suggest the ability to choose this file format :

-by default on connection (in-db connection or in-memory alias)

-ability to choose the format for the writing tool itself.

Best regards,

Simon

Hello all,

When looking at the Results window, I often find it a headache to read the numeric results because of the lack of commas. I understand that incorporating commas into the data itself could make for some weird errors; however, would it be possible to toggle an option that displays all numeric fields with proper commas and right-aligned in the Results window? I am referring to using a display mask to make numeric fields look like they have the thousands separator while retaining numeric functionality (as opposed to converting the fields to strings). 

What do you think?

Hello all,

Here the issue : when you have a lot of tables, the Visual Query Builder can be very slow. On my Hive Database, with hundreds of tables, I have the result after 15 minutes and most of the time, it crashes, which is clearly unusable.

I can change the default interface in the Visual Query Builder tool but for changing this setting, I need to load all the tables in the VQB tool.

I would like to set that in User Settings to set it BEFORE opening the Visual Query Builder.

Best regards,

Simon

I decided to get real fancy when building a standard macro the other day. I checked the box on my macro input that made the connection optional:

It worked really well. My macro then became more complex, so I changed it to a batch macro. To my great surpise/astonishment/shock, the optional incoming connection is no longer optional:

The standard macro is working as expected on the left, but the batch macro is producing an error because my optional connection is requiring that something be connected to it.

I've been told that the code to make it optional is not there for batch macros and that this would be a product feature/improvement.

Hello,

I think the option Overwrite File (Remove) shouldn't throw an error if the file is not present

Or, I don't know, make 2 options : one with fail if file is missing, the other to not fail.

This idea is the same than https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Overwrite-Table-for-output-write-indb-should... but for files.

Best regards,

Simon

Hello,

SQLite is :

-free

-open source

-easy to use
-widely used

https://en.wikipedia.org/wiki/SQLite

It also works well with Alteryx input or output tool. 🙂

However, I think a InDB SQLite would be great, especially for learning purpose : you don't have to install anything, so it's really easy to implement.

Best regards,

Simon

Dear Developers,

it would be great, if SSO would be possible for Salesforce connector. 

Our company is not so much in favor distributing log-in details for a service account. 

If there is already a solution in place, than perfect, but if not, I guess this functionality would be a lever to use Alteryx in our company.

Best Regards,

Johanna 

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

It would be great if we could set the default size of the window presented to the user upon running an Analytic App. Better yet, the option to also have it be dynamically sized (auto-size to the number of input fields required).

I find the Run Command tool to be counter-intuitive: rather than supplying a required I/O parameter (in at least one of "Write Source" and/or "Read Results"), I would rather just use a "Block Until Done" approach to 1. write file, 2. issue custom system command, 3. read file.  An even simpler example is the case where I don't need I/O to/from the system command... in that case, I just want to issue the command, nothing more.  But the current tool will require me to specify a dummy file, which is counter-intuitive and also leaves that unnecessary file somewhere.

To fix this up without breaking existing user implementations, the "idea" is:

• Do not require either "Write Source" or "Read Result" ... allow both to be blank.
• Allow (but don't require) any of "Command," "Command Arguments," and "Working Directory" to be dynamically populated from fields in the data streamed into the tool.

So... any existing user implementation should be unnaffected... but these changes would allow users to implement system commands in a more intuitive manner, and even allow for very dynamic system commands based on the workflow.

Thanks!

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

See the discussion on this page: 

https://community.alteryx.com/t5/Data-Preparation-Blending/Batch-macro-only-iterates-one-time-expect...

If the tables in the config window has lots of rows, it is quite complicated to find those of interest. 

Please add a filter or search option (e.g. by the field name) to display only the relevant rows.

It would also be helpful to select or deselect multiple selected rows with one click.

Find an example from the "Select-Tool":

Today, I am able to take an excel file from a folder and drag it onto the canvas, which automatically creates an Input Data tool.

I would like to be able to drag an excel file right from outlook to do the same! 

Where it stands now, only a file input tool can be used to pull data from Google BigQuery tables. The issue here is that the data is streamed and processed locally, meaning the power of BigQuery processing isn't actually being leveraged.

Adding BigQuery In-Database as a connection option would appeal to a wide audience. BigQuery is also standard SQL compliant with the SQL 2011 standard, so this may make for an even easier integration.

Hello All,

As of today, Alteryx can use the proxy settings set in Windows Network and Internet Settings "Server pulls the proxy settings displayed in Engine > Proxy from the Windows internet settings for the user logged into the machine. If there are no proxy settings for the user logged into the machine, Engine > Proxy isn't available within the System Settings menu.". Then, you can override the credentials (but not the adress) in system settings but also in user settings.

The issue : in many organizations, there are several proxies that you can use for different use case. And by default, it can happen access to API are blocked by these proxies. The user, which is not admin cannot change his Windows Settings... and even if it's done by IT, it will impact all the system, including other software and leading to safety failures.

What I suggest :
-ability to change credentials AND adress

-a multi-level settings for both credentials and adress:
    default : Windows Settings
    System Settings
    User Settings

    Workflow Settings

    Download tool/ Settings

Best Regards,

Simon

The canvas has 3 options as demonstrated by exhibit A:

The user settings can change 2 of the 3 defaults as demonstrated in exhibit B. The layout default and connection settings progress can both be defaulted for all new workflows:

Thus, I would propose that a user setting be added to the annotation box so that I can set the default to hide.

Mic Drop

all too often, we build an alteryx flow just to realise that step 8 out of 10 was wrong -so back to the beginning and rerun the entire thing.   this often is tedious if your work requires a big data set.

So there is a workaround, using the Cache Macro which can be downloaded (but this does require quite a bit of fiddling with containers; disabling items; setting flags; etc) - but it would be good to allow the user to "restart from here" like you can with a powerpoint slide deck.    I appreciate that this may be tricky since Alteryx may be flushing data out of memory as it goes along, so it cannot restart from any arbitrary point - but if we put the workflow into a "testing cached mode" to cache data at each step; or allowed users to set particular controls as a breakpoint and cache at these points, that would help immensely.

Thank you

Sean