Alteryx Designer Desktop Ideas

I would love a tool to be created for looking up a value in a table based on a condition. It could be called "Lookup." One input to the tool would be the lookup list, the other is the main database. Inside the tool you could enter functions that can query the lookup table and return the results either as an overwrite of an existing field in the main DB or as a new field in the main DB, similar to the options in the Multi-Row Formula tool.

Here is a link to my post in Community that explains the problem. The solution, in a nutshell, was to create a Join (which resulted in millions of additional rows), run the conditional formula, then filter to get rid of the millions of rows that were created by the Join so only those that met the condition remained (the original database rows).

Here is the text of my Community post describing my project (slightly modified for clarity):

Table 1:  A list of Pay Dates (the lookup table)

Table 2:  Daily timekeeper data with Week Start and Week End Date fields.

The goal:  To find the Pay Date in Table 1 that is greater than the Week Start Date in Table 2 and no more than 13 days after the Week End Date in Table 2.

[Table 2: Week Start Date] < [Table 1: Pay Date]

and [Table 2: Week End Date] < [Table 1: Pay Date]

and DateTimeDiff([Table 1: Pay Date], [Table 2: Week End Date], 'Days') <= 13

There are many different flows I could use this type of tool for that would save time and simplify the flow.

Thanks!

Github support. push/pull your workflow code directly to/from a repo. I posit this is the single biggest feature misisng form Alteryx -and I'm be happy to blab on and on to the product team about how not having this is a huge miss.

Hi all,

Hope you are doing well! Recently I have come across a use case where I had to dynamically rename columns based on Field name ánd position. While I was able to come to a solution using a set of tools, it got me thinking: would it be possible to include the Fieldnumber function exactly like already has been done in the dynamic select tool (i.e. 'Select via a Formula - Column Position' example)?

For example, one would write: IF ([FieldNumber] = 1) OR ([FieldNumber] = 3) OR ([FieldNumber] = 7) THEN [_CurrentField_]+"_Code" ELSE  [_CurrentField_] ENDIF

Hello all,

We all have experienced these last years the now famous concept of hide/unhide password :
Here a few examples of it

I would like this exact principle everywhere we have a password on Alteryx.

Best regards,

Simon

Hello,

This is a popular feature on other tools, such as Talend (now Talaxie) : the ability to export the workflow as a vectorized screenshot in svg.

Why ? it helps to build documentation, svg being vectorized, it means the picture can be zoomed in without losing quality.

Of course, that would mean before that Alteryx use svg for icons as required here https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/svg-support-for-icon-comment-image-e...

Best regards

Simon

Formula Tool --> Functions --> Operators list

The operator titles for the two comment functions are too similar, the difference cannot be determined unless checking the hover text.

Can the title for /* Comment */ be adjusted to make it more clear that it is for block or multi-line usage?

I didn't understand the difference until I saw this post on LinkedIn:
https://www.linkedin.com/feed/update/urn:li:activity:7165816592063266817/

/* Comment */ --> /* Block Comment */   |   /* Multi-line Comment */

Writing to XLSB Files using Delete and Append does not behave properly.

Alteryx currently is having an issue with writing to an XLSB file using the Delete and append option with Take the file/table name From field.

Issue:

• Old data gets deleted, and new data is added but on the wrong row.
• New data is added after location where old data was originally.
• This output error for XLSB files only shows when using Take the file/table name From field. Static paths are fine.

Workaround:

Create a Batch macro to simulate the Take the file/table name From field function without actually using it.

Example of Issue:

I received a "string variable switched type" error on the filter tool performing a basic filter on the value column of "is not empty" after a transpose tool.  The value column is datatype of  V_String 255.  So even though the values are null, blank, number, text, it is all string as per the data type column flowing in.  When switching from basic to custom with formula: IsEmpty([value]) same error.   BUT, when using the Formula Tool to generate a new column for true/false there is no error. Also the Fitler Tool works as expected with IsNull on this dataset.

Please look into the isEmpty code in the Filter tool so that it behaves correctly.

Please note that pre-splitting the data with the isEmpty flag column using the formula tool, applying IsEmpty Basic Filter  to the True and To the False both worked without incident.  

What would be nice is if there is an error in the filter tool that it would output those to it's own stream.  Something like - True (T), False (F), Error (E).

Allow users the ability to add a delay on the connection between Control Container tools. I frequently have to rerun workflows that use the control container because the workflow has not registered that the file was properly closed on outputting from one output tool to the next. The network drives haven't resolved and show that the file is still open while its moved on to the next control container. Users should have an option in the Configuration screen to add a delay before a signal is sent for the next container to run. 

In the past I was able to use a CReW tool (Wait a Second) in conjunction with the Block Until Done tool to add the delay in manually. But I have since converted all of my workflows over to Control Containers. Since then half of the times the workflow has run I encounter the following errors.

In the dynamic input tool,

Where you “Read a List of Data Sources”, there should be a radio button below the “Action” field, to   

“INCLUDE FIELD OF DATA SOURCES”,

Then you’d have an output field with the isolated name from which the data was sourced. You wouldn't be required to "include full file path" then parse out the sheet the data came from. 

Add Unicode category to the cleansing tool

Hi currently if you use the cross tab tool and the names of the new fields should have special characters they end up being replaced in the new headers with underscores "_", and then need to be updated in someway. It would be great if this was all done in the tool. In other words the new headers have the special characters as desired

Hi is it possible to look at alteryx workflows being run when a file has been dropped into a file or somehting along those lines? I.e an external activty has taken place

Alteryx is great for for forecasting but it would be useful if we could use it for back casting (predicting historically). Might have fewer use cases than forecasting but would still be useful.

The TO field (and I assume other fields) in the Email tool seem to have a 254 character limit - this should be increased heavily as there are many distribution lists that will go above this character limit!

• Solved: Email tool recipients list truncating emails - Alteryx Community
• Solved: Email Widget: Cut off all the emails in the "To" r... - Alteryx Community
• Re: Email Address Truncated in the "To" Field - Alteryx Community

A distribution list works but is not ideal. Thumbs up if you like this idea!

Hey it would be great if we could use alteryx designer on macs (without needing to use VDIs or splitting the hard drive)

Hi Team,

I understand there is no .dmg i.e. direct macOS installation package is available to install directly on Mac instead we have to use other third party apps to install WindowsOS and then use it.

However I would suggest that if Alteryx can have a web version or something called Alteryx Public (similarly that Tableau has for their users) which users can use and explore the tools with limited to basics functions and to understand the UI and experience the tool itself by having hand-on it.

Please find the below Tableau Public snapshot for reference purpose.

I am looking forward as I am keen on exploring Alteryx as a beginner and become expert one day :)

Thanks,

Sachin

Hi,

Due to our setup, we need to have the path defined as Environment variables, so they will point to different paths in case a user opens the WF locally or the server is running it.

The issue is that the path of dependency does not accept the windows defined variables:

Thank you!