Alteryx Designer Desktop Ideas

When selecting a colour for a container I would like to be able to click randomize and let Alteryx pick the colour, however I would like the option to click 'random new colour' so it picks a colour not already used in a container on the current workflow  I should then be able to customize the transparency as per normal.

I'm using .sv file format for compressing large files and using them in Alteryx.  .sv is call a Alteryx Spatial Zip file.  This format seems to offer the highest level of compression of all the Alteryx file format types.  Is this suitable for text also?  Is it usable in real time vs uncompressing first then using in a workflow?  If not, I think a compressed real time file format would be a nice addition.

for the past 8 months I have been using alteryx and mostly working with the connect in db components , there are many issues which I am facing and i this this can be improved 

1. there is no such  flexibility of creating a table with the keys defined which is the most important pillar in database, also the options provided are limited , i.e. to create a new table , delete and append, drop table and recreate, 

now, there are many times where in we  need to update the tables based on the keys, which i find missing. Also how the option is defined is create a new table, next time if the job is run it states that the table is already created, for which we need to manually change the option in the next run.

 

2.which switching between in db and alteryx , if the records are more the alteryx lags completely and the job keeps running for hours , how can we achieve the flexibility  of alteryx designer if there is such bottleneck.

 

3.the flexibility that is provided with alteryx designer should also be given to in db components.

4.the parameters defined in the workflow can not be accessed in the in db  formula tools but can be used in the designer formula tools. this reduces the flexibility.

 

please look into the same

Can an interactive mapping tool be added as an output tool? 

When reports, files, or tables are generated, it would help to be able to view them on an interactive map.  Currently I am trying to show where high population growth is located for large areas, ie-entire US, entire State(s), etc., so the user needs to view where these areas are on a map.  Ideally, it would be nice to have additional layers seen on the map as well, for example, our current locations, competitor locations, etc.

I love the new Basic Filter option and it makes writing filters easy/self-expanatory for new users and helps with functions like isnull(). However, I'm almost always writing what are now called 'Custom Filters' and it takes two clicks to do this.

From a User Experience perspective it would be great if you could click in the expression box to write the filter rather than having to check the customer filter check box, or start by creating a basic filter and then make it more complex using the custom filter box without having to check the tick box.

Following on from this and something that is probably a lot harder to implement - But with the new basic filter, it would be great to have a list of available fields populate the options to filter by - Similar to the option that you get in Calgary. E.g Country == and then the drop down list would contain whatever is available in the data (e.g. Spain, UK, USA, Etc...)

how to share Custom Tool Palette (along with Macros) with other users. 

 

For eg, I have created a custom tool palette named "Adhoc Analysis" with few macros; something like attached.

Now, how to make sure that all my user base can have same palette in their local alteryx designer. 

 

After some research, I did found that I could share macros with them by putting all relevant macros on Alteryx Server, and users could then pick the macros from there. 

 

Although, I wanted to suggest this as an Idea for future releases, it would be great to have an option or way, on how to share this with users in their local designer without much hassle.

 

Not sure, if this is something worth exploring from Alteryx development team side. But thought of suggesting to community if this could help others.   

 

Thanks for your help. 

Ravi Sharma

Lets say we have data for 3 different regions coming from input file/DB. Asia, LA and EMEA region data are all in one file.

 

After the transformation, checks which were needed, now I want to output my results per region. 

Due to user access to data, we have designed 3 different folders - one for each region.

 

So, Asia region output should go to --> ASIA Folder, and similarly for rest of the regions. 

 

Currently, there is no option to dynamically select and change the output folder path in output tool. 

 

It would be great to have a way to be able to choose output folder based on a field value.

We were browsing the Alteryx Gallery recently and thought it would be great if the Alteryx Gallery was in Connect, or more like Connect - with certified macros/workflows and voting ability, making it easier to find the most popular macros and how many people are using them.

 

PS - I didn't see either Gallery or Connect available as labels 😕

I got the requirement to read the file with same structure from different path and different sheet, so I worked and identified a way to achieve this requirement.

 

Step 1: List the files that are required to read from the different path and create it Excel with the file name and respective path.

 

 

Step 2 : Create batch Macro give control parameter as filepath and mention the correct template.

 

 

Step 3 : Create a workflow add source input and Map Source file i.e. list of files with path.

 

 

Finally you can see the all the data are merged together write in your output as single file. You can additional transformation if you want process any business logic further and write in output.

Note: Adding additional file name source path will be enough for additional file processing.

 

 

 

 

Would be nice if in Designer customer's may want to upload and reference  a " DATA DICITIONARY - METADATA REPOSITORY file when working with various input source to transform data . 

Organizations that are mature in their data governance strategy implement special software that extracts, manages and provides access to data dictionary of data assets in multiple databases such as  ERWIN to maintain schema for enterprise. 

Within DESIGNER access to a file METADATA REPOSITORY held in DESIGNER customer may easily select a list of columns  fields or attributes from that file to manipulate data elements using DESIGNER and provide all the relevant information required they wish to massage the data.

Possible Attributes that may be in data dictionary file:

Table name

Column Name

Data Type
Foreign Table

Source

Table Description

Sensitive Data

Required Field

Values

This might be a dumb ask, but I run into this alot. I have a workflow that has over 1000 tools and is super long. I would like to be able to to either right click and lock the connection sting so i can let go of the left click , scroll down to the tool, and then click on it to make the connection. Also, it would be nice to have the ability to right click on a tool and click a button "Connect to last used connection" as i sometimes join to the same table multiple times. Lastly, I just thought it would be cool if we can defined tools that are connected to the most so when i right click on another tool, i can open a drop down and select one of the most joined to tools, without even having to click on the original.

There are several tools and tool categories that I have limited knowledge of.  It would be a nice feature to be able to right click on a tool and in addition to  "help",  have an option to view a video (on-line) overview of the tool or tool category  including examples of using the tool

It would be helpful to have a unique feature within Calgary in order to return a unique count or a data extract. The current Crss count will error if there are two many rows.

Alteryx has different behaviours for conversion errors depending on the type of conversion desired. When converting from string to date data type, a conversion error will generate a NULL value. When converting from a string to a numeric data type, a conversion error will generate 0. Why the different behaviours? There is a lack of harmony here. 0 is a valid value and should not be the generated value for a failed string to numeric conversion. It should be NULL.

 

When I perform data type conversions, i do not apply them directly to the source field and then cast it. If there is a conversion error, then I have lost or corrupted the source information. Rather, I create a target field with the desired data type and use a formula to apply a conversion, such as datetimeparse or tonumber. Finally, I do a comparison of the source and target values. If the datetimeparse generated a NULL then I can PROGRAMMATICALLY address it in the workflow by flagging or doing some other logic. This isn't so easy to do with numerics because of the generated 0 value. If I compare a string "arbitrary" to the generated 0 value as a string then clearly these do not match. However, if I compare a scientific value in a string to the converted numeric as a string, then these do not match though they should. My test of the conversion shows a false positive.

 

I want a unified and harmonised conversion behaviour. If the conversion fails, generate a NULL across the board please. If I am missing something here and people actually like conversion errors to generate 0 please let me know.

Currently there are bulk loaders within alteryx for Teradata, Oracle and SQL Server.
It would be great to have a bulk loader for AWS Redshift in order to fully industrialize the workflow instead of using AWS S3 and then use a separate AWS Datapipeline for scheduling

Hi,

 

Please provide users the option of downloading course videos and transcripts. If it is already there, please let me know.

 

Regards,

Meenakshi

When I perform data type conversions I sometimes receive conversion errors. There is not a slick way to programmatically handle these that I am aware of. Instead, I have to manage them with half a dozen tools or really unsightly expressions in formula tools. As an example, I have a string field with a value "two" and I want to convert to a decimal or int. I receive a conversion error and the value is either "0.000" or "0". This is clearly wrong and I want to have a NULL value instead. I want to use a function to attempt the conversion in the formula tool so i can nest it inside conditionals in a cleaner fashion.

Here is a reference to the try_cast doc:

https://docs.microsoft.com/en-us/sql/t-sql/functions/try-cast-transact-sql?view=sql-server-2017

 

 

I want to keep my user settings, pinned palettes, and other configurations in a file. I can keep the file versioning purposes, backups, use across multiple machines, silent installs, and other uses.

 

It will make life easier. Thank you.