Alteryx Designer Desktop Ideas

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!

To rename a workflow, usually we have to save and then name the workflow. Could you please consider adding a feature of renaming a workflow after "Close" & "Duplicate"?

Hello all,

As of today, the error message when trying to activate a license doesn't give any useful information :

I want to know :
-do I manage to access to the Alteryx Licensing? (so maybe a security/proxy issue.. so I have to contact my IT)
edit : for that there is another message usually

-is the key correct but not more seats? (so I have to contact the Alteryx License manager) Or another issue?
Here, I perfectly know the license key is correct so the error message is really misleading.
-also displaying the machine id as it appears on the License portal would help.
-and anything that can be helpful to debug.

Best regards,

Simon

I know that the container title/label should or can be short, and as much descriptive as possible. Also, adding extra comments inside the box helps to a more detailed explanation on regards what process is run inside the container. Visually, if I collapse the container, the "Short" title given can't be of much help.

Could it be possible to enhance the "caption" for the "Container" title? I mean to allow to type 2, 3 or more lines of text?. This will make the Container title more descriptive and visually will allow to have the containers collapsed but with a reasonable amount of text that describe (as much as possible) what happens inside the container.

At the moment, If I type certain amount of text, the container expands according to the length of the text 

Below is the typical container Title 

Below is the current situation if a person would like to give a bit of more description in the "Container" header (The container expands)

An dream would be to have the workflow with all containers collapsed and with titles that tell you what they do (see image below)

I am using Alteryx as an ETL Tool and then QlikSense for data visualization.

Alteryx only gives QVX outputs which are the old version QlikView files. It works for QlikSense but it slows down the system. So, the QlikSense support suggested using QVD outputs. 

I want to suggest supporting QVD files as QlikSense is being used more widely instead of QlikView, most users are migrating to QlikSense.

It would be more useful and efficient if Alteryx supports latest file format.

Hello all,

It's really frustrating to have an "alteryx field type" in In-Database Select. It doesn't even make sense since we're manipulating only data in SQL database where those types does not exist. What we should see is the SQL field type.

Best regards,

Simon

Hello all,

When using in-database, all you have in select or formula are the Alteryx field types (V_String, etc..).

However, since you're mostly writing in database, in the end, there is a conversion of Alteryx field types to real SQL field types (like varchar). But how is it done ? As of today, it's a total black box. Some documentation would be appreciated.

Best regards,

Simon

Hello all,

Sometimes, when you have too much time to retrieve your tables metadas, you can have this message

Initialization Timed Out: Workflow must be run for field meta info to be accurate.

From what I understand, it's Alteryx and the source system that drives the time out value. However, I have some cases where the long time is "normal" and that really hurts the user experience.
So, I would like the ability in settings to change the default value.

Best regards,

Simon