Alteryx Designer Desktop Ideas

Hi,

     Currently loading large files to Postgres SQL(over 100 MB) takes an extremely long time. For example writing a 1GB file to Postgres SQL takes 27 minutes! This is serious impacting our ability to use Alteryx as an ETL tool for loading our target Postgres Data Warehouse. We would really like to see the bulk load capacity to Postgres supported by Alteryx to help alleviate the performance issues.

Thanks,

Vijaya

Hi GUI Gang

At the moment, I have a lovely formatted XLS with corporate branding, logos, filled cells, borders etc.  The data from the Alteryx output needs to start in cell B6.  I have tried the output tools to this named range, but Alteryx destroys all the Excel formatted cells in the data block.

As a workaround on the forums, many Alteryx users pump out to a hidden "Output" tab, and then code =OutputA1 in the formatted sheet.  This looks messy to the users who then go hunting for the hidden tab.  Personally I end up pumping the workflow out to a temporary CSV file.  Then opening that in Excel, selecting all, and then pasting values in the pretty Excel file.

This is fine for one file, but I need to split the output report block by a country field and do this 100s of time for each month end.

Please can we have a output tool that does the same as my workaround.  Outputs directly from a workflow to a range in Excel that doesnt destroy the workbook's formatting.

Jay

Create new connector to pull Salesforce Reports

We are a large company with tens of thousands employees using Salesforce on a daily basis. Over the years, we have worked with Salesforce to make many customizations and create many reports to provide data for various reporting needs. However, we have increasingly found it inefficient and prone to error to download the reports manually. We have many teams using the Salesforce reports as a base to create additional business insights.

Alteryx is a great tool to manage data ETL and workflows, but it does not support pulling data from Salesforce reports directly. Instead, it only offers connectors to pull data from base Salesforce objects. The data from Salesforce objects such as tables can be useful, but do not necessarily offer the logical view of Salesforce reports, and may require a lot of efforts to reconcile the data consistency against the reports our users are used to. Sometimes, it may be impossible to repeat producing the same data from Salesforce tables as those from Salesforce reports. That in turn would cause a lot of efforts spent by the reporting teams, their audience, and users of the Salesforce reports to match things up.

Salesforce does not have any out-of-box solution to schedule downloading the reports. At our request, their support team did some research and have not found a good 3rd-party solution in the Salesforce App Exchange ecosystem that supports this need.

I strongly believe this is a great opportunity for Alteryx. Salesforce already has an API that allows for building custom applications to pull Salesforce reports. However, most Salesforce users are more business oriented and do not necessarily have the appetite to engage with their IT staff or external resources provide to develop such apps and bear the burden to main them.

I have attached the Salesforce Reports and Dashboards API Developer Guide for your reference.

Sincerely,

Vincent Wang

DELETE from Source_Data Where ID in

SELECT ID from My_Temp_Table where FLAG = 'Y'

.... 

Essentially, I want to update a DB table with either an update or with the deletion of rows.  I can't delete all of the data.  My work around will be to create/insert into a table the keys that i want to delete and try to use a input/output tool with SQL that performs the delete.  Any other suggestions are welcome, but a tool is best.

Thanks,

Mark

I think we would all benefit from having IntelliSense within Alteryx. Just think about how much quicker writing formulas wold be or any time you need to reference your data within the various tools.

There are few workarounds for this task, but it would be really very easy if Data Cleansing Tool could delete Null Rows and Null Columns. After all its just a macro which can be modified and re-packaged into Alteryx Designer.

Currently, to delete a null row requires multiple columns validation for common Null attributes,

similarly to delete a null column every column has to be compared on a row-level and flagged for removal. Both of these approaches are clumsy.

Wouldn't it be so simple if Data Cleansing Tool gave such check boxes !!!

The sum function is probably the one I use most in the summarize tool. It is a silly thing, but it would be nice for "Sum" to be in the single-click list, rather than in the "Numeric" category...

Move sum function

When moving a tool container, all of the tools within it become mis-aligned with the canvas grid.  Moving any single tool immediately re-aligns it to the grid, which puts it out of alignment with the rest of the tools in the container.

Example:  Put 3 tools in a row in a tool container, all aligned horizontally.  Next, move the container.  Now, move the middle tool, then try to place it back in alignment with the other two.  You won't be able to, because they are out of alignment with the canvas grid.

Please fix this.  

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 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?

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":

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

Hello Alteryx Devs - 

When I got to write some scripting in the formula tool, my data stream properties should be the first to be suggested once a user starts typing a letter, not the last. 

uppercase(Ad -> gives me:

DateTimeAdd

FileAddPaths

PadLeft

PadRight

ReadRegistryString

[Address]

I think we would need a dedicated R macro to ascertain the chances anyone in is going to need [ReadRegistryString] before they need a column of their own data that starts with [Ad...]

Easy fix.  Makes a big difference.  

Thanks.

The following idea might not be as valuable as some of @SeanAdams posts, but it would save this user precious fractions of time.   When I leave the canvas with my mouse (point A) to go up to the pallet I select and drag the tool down to the canvas.  Sometimes I do right-click and go through the menus to add the next tool, but generally I go through that labor only when I'm inserting in-stream the tool.  So here is my idea:

Double-Click your NEXT tool and it "Alteryx-ly" appears on your canvas in proximity to the hi-lighted (last) tool.  Better yet, connect it!  Now I can move from the pallet to the configuration panel directly without having to move my mouse down to the canvas and then over to the configuration panel.

Hopefully, my friend @Hollingsworth will find this time-saving idea worthy of a star.  Speed demons like @NicoleJohnson and @BenMoss might not need this turbo boost, but at my age it is worth the ask.

Cheers,

Mark

Maybe it was a lack of planning, but I've had a need to rename a variable within a workflow and would like to (outside of the XML view) be able to rename the variable so that downstream tools don't have to be reconfigured (e.g. formula, join, union).  

As @JordanB mentioned in his post (https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Stop-workflow-on-a-condition/tac-p/74403#M19...) - there's a common need to stop a worfklow when an condition is met.

However, at present there's no way to do this without generating an error.

Please can we either alter the message/test component to allow for error-free termination on a formula condition; or alternatively implement the fuller idea that Mark ( @MarqueeCrew) mentioned in his programmatic Detour idea?

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Programmatic-Detour/idi-p/12763

Now that we have a Snowflake Bulk Loader option, it would be great to utilize the built-in Snowflake internal staging.  This eliminates the need for an end-user to have the technical know-how or access to IT resources to utilize a separate S3 bucket and generally reduces friction in the process. 

There was pretty widespread support in the original Bulk Load thread: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Snowflake-Bulk-Loader/idi-p/105291/page/2#co...

I superimposed multiple screens and multiple workflows and rendered them into a single image below. Have you noticed something?

 There is a space never being used at all times, painted in yellow for emphasizing...

Actually this is an enough space for ads 🙂 And we can make the designer for free...

Though I suggest a better placement and use of the available screen space;