community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the like in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea
0 Likes

Example:

 

Equipment IdTypeClean Equipment ID
123LLine123
123SSubstation123
S156Substation 156
123XBus123
123L6Delivery point1236

 

If I want to create the 'Clean Equipment ID" I would have to use a complicated RegEx expression. Wouldnt it be easier for the end-user to have a function to do so? Like Exclude(string,character)?

In this case it could be: exclude([equipment id],"ABCDEFGHIJKLMNOPQRSTUVWXYZ") and if I wanted just letters it could be exclude([equipment id],"0123456789").

 

0 Likes

For most of our "Production" mode, we launch our apps with an xml file containing the parameter send to the app.

We would like to have the path of this file in the Engine Constant.

0 Likes

This wasn't pretty (actually, it was challenging and pretty when I was done with it)!

 

My client receives files that include a static and dated name portion (e.g. Data for 2018 July.xlsx) within the file there are multiple sheets.  One sheet contains a keyword (e.g. Reported Data) but the sheet name also includes a variable component (e.g. July Reported Data).  I needed to first read a directory to find the most recent file, then when I wanted to supply the dynamic input with the sheet name I wasn't able to use a pattern. 

 

The solution was to use a dynamic input tool just to read sheet names and append the filtered name to the original Full Path.

[FullPath] + "|||<List of Sheet Names>"

This could then feed a dynamic input.

 

capture.jpg

Given the desire to automate the read of newly received "excel" data and the fluidity of the naming of both files and sheets, more flexibility in the dynamic input is requested.

 

Cheers,

 

Mark

0 Likes

There are quite a number of XML configurations available in Alteryx Designer as well as in Alteryx server.  And there are possibly in different locations and each of them them is specifically for different configuration options.

 

Currently, there it isn't a official list of all these configuration files as well as all the configurable options.  It would be good to have a centralized area to configure and visualize all these.  This not only helps easier to know how to customize the tool but also help easier to maintain the backup/restore of the configuration files.

 

Moreover, there are possibly some settings go into the registry.  This would be also good to have this centralized as well.

 

Ideally, a user interface would be good for these configuration with general/advanced tabs to classify the possible configuration.  For server, ideally, it could be comes up the controller to distribute all these settings.  For Designer, once it is configured to the Gallery, it should be able to grab the configuration and apply in the machine.

 

Hope all these make sense and do-able.

 

Thanks.

 

Regards,

Kong

0 Likes

It would be very helpful to have a SOQL Edit textbox for the entire SOQL statement not just the WHERE clause.   This would allow us to select fields based on parent or child relationships to the table as well.

0 Likes

Sometimes in a crowded workflow, connector lines bunch up and align across the title bar of a tool container.  This blocks my view of the title, but also makes it hard to 'grab' the tool container and move it.

 

Could Alteryx divert lines around tool containers that they don't connect into, or make tool containers 'grab-able' at locations other than the title bar?

 

4-13-2016 1-08-53 PM.png

0 Likes

When working on the Weekly Challenge #108, I was trying to design a non-macro solution.

 

I ended up settling on the Generate Rows tool and was trying to find a way to generate rows until I had reached or exceeded the maximum density, however, I ran into an issue where I'd always have one too few rows, since the final row I was looking for was the one that broke the condition I specified.

 

In order to get around this, I came up with the following solution:

 

Spoiler

 

Idea_IncludeConditionBreak_GenerateRowsTool.PNG

Idea_IncludeConditionBreak_GenerateRowsTool.PNG

 

Essentially, I just set my condition to twice that of the true threshold I was looking for. This worked because I was always doubling the current value in my Loop Expression, and so anything which broke the 'actual' condition I was looking for ([MaxDensity]), would necessarily also break the second condition if doubled again.

 

However, for many other loop expressions, this sort of solution would not work.

 

My idea is to include a checkbox which, when selected, would also generate the final row which broke the specified condition.

 

By adding such a checkbox, it would allow users to continue using the Generate Rows tool as they already do, but reduce the amount of condition engineering that users are required to do in order to get that one extra row they're looking for, and reduce the number of  potentially unseen errors in their workflows.

0 Likes

The idea is the ability to skip tools in a workflow. Check the attached example:

 

Input (TRX_TABLE): Contains transactional raw data (unstructured & uncleaned data)
Filter (TRX_DATE <= 90 days from TODAY): It only filters the data 90 days old from today. Works as an incremental data loader
If the filter tool is NOT SKIPPED the workflow loads the filtered data (incremental behavior)
If the filter tool is SKIPPED the workflow loads all the data (full behavior)
This way I can quickly switch between both modes for testing & production environments

0 Likes

Hello, I am very new to Alteryx, so my suggestion might appear elementary for the veteran-users. From the standpoint of adoptation by less technical people (moving from Excel to Alteryx), would it be possible to take common scenarios of Fuzzy Matching and automate them?

For example, if you have 2 databases and you want to match and clean them up, you have to have close to 10 steps, with sorting, adding unique identifiers, joining, fuzzy matching, etc. Just look at your video named "Fuzzy Matching" or other videos for Tableau+Alteryx. They idea is basic. If you know most common use cases and you have already developed a methodology for how to solve these cases, why not have them as part of the tools library?

Also, when matching, for example universities, wouldn't it be easier if all those common, aka appearing many times, words were automatically suggested to be removed from the "match". Example: University A and Univeristy B are two different Universities, but they share the common word "University". While it's important that this word is there, it is not the reason to pair these two together. Maually going through and identifying and typing these common words is an extra step. It would be much easier to have a pop list of these common words and the count of records in which they appear, sorted by the count, and a check box to include or exclude the words.

Thank you,

Olga

 

Link to the Fuzzy Matching video. Check Minute 9:41.

https://www.youtube.com/watch?v=JlZiM2YSCCY&index=13&list=PLfSLx4WE4q52YoGEzJEBalfNou6jfRTF0&nohtml5...

 

0 Likes

Instead of counting the number of occurrences of the delimiter and then specifying it is there a way to split column for:

1. Every occurrence of the specified delimiter?

2. Only the last occurrence

3. Only the first occurrence

 

Thanks,

0 Likes

Hi,

 

I am sure that I can't be the only person that would be interested in an output tool that allows categorical fields on both axes.  THis would allow you to visualise the following example and I would suggest that this was either similar to the heatmap with boxes or the colour / size of the entry was determined by a third numerical value - such as 'Confidence' from the table below.  THere might be ways to extend the idea as well as having a fourth parameter that puts text in the box or another number but it would be useful and not too hard I am sure.

 

LHS

RHS

Support

Confidence

Lift

NA

{Carrots Winter}

{Onion}

5.01E-02

0.707070707

1.298568507

210

{Onion}

{Carrots Winter}

5.01E-02

9.20E-02

1.298568507

210

{Carrots}

{Onion}

4.39E-02

0.713178295

1.309785378

184

{Onion}

{Carrots}

4.39E-02

8.06E-02

1.309785378

184

{Peas}

{Onion}

3.20E-02

0.428115016

0.786253301

134

{Onion}

{Peas}

3.20E-02

5.87E-02

0.786253301

134

{Bean}

{Onion}

2.20E-02

0.372469636

0.68405795

92

{Carrots Nantaise}

{Onion}

2.08E-02

0.483333333

0.88766433

87

 

Many thanks in advance for considering this,

Peter

 

0 Likes

I asked this before.  WHY DO WE HAVE TO HAVE A POP UP WINDOW OPEN UP EVERY TIME WE RUN ALTERYX?!  I asked this before, and the comment was made, "there is a check box to turn it off in the settings."  Yes, that is true, there is a checkbox!  And guess what, to my surprise (insert sarcasm here), IT DOESNT WORK!  THE MOST BASIC, EASIEST THING YOU CANT GET RIGHT, and that is EXTREMELY ANNOYING.

 

Just LOST THE INTRO WINDOW.  WE ALL KNOW ITS ALTERYX WHEN WE OPEN IT, DO YOU NEED THAT MUCH MORE ADULATION THAT I HAVE TO CLOSE A WINDOW THAT REMINDS ME THAT I AM USING ALTERYX?!?!  
Maybe I should send an email to alteryx to remind them I am using their product, will you feel even more important then?  Pardon that slam here in my nastygram, but this is JUST AMATEUR!

 

A multi billion dollar company, and youre wasting effort with this.  GEEZUZ

0 Likes

It may just be me, but after I upgraded to 2018.2, the Table/Query edit window doesn't take up the full window when I maximize the parent window. 

 

I'm surprised no one else has mentioned this, maybe it's just me.  See attached.

0 Likes

Is it possible to have a Sum(Column) or Total(Column) functions in formula tool? it will make the calculations much better as we don't need to use "Sum tool + Append tool + Formula tool + Select tool" or "couple of formula tools and then a select tool".

0 Likes

I have a problem when transferring records between different O365 Sharepoint Sites.  It seems that Alteryx cannot maintain 2 separate connections at the same time.  I can transfer fine if I read from one site to a temp file and then, in another workflow, read from the file and write to the second site.

 

I can work around the problem using Block until Done, but there are some situations where I need to be able to compare between lists in 2 different sites and write back to one or both depending on the results.  it would be much more convenient to be have multiple connections open simultaneously.  I'm aware that Alteryx uses the SharePoint API to move information around.  This API does allow multiple connections.  I'm not familiar with the internals of how Alteryx accesses the API, perhaps the OAuth token is shared through out the workflow process,  but this should be posssible

 

Thanks for considering this

 

Dan

   

 

0 Likes

Hello Alteryx,

 

In communicating with your agent Eddie Wong about a question (ref:_00DE0JJZ4._50044uMC7T:ref), he confirmed that Alteryx currently does not have an option to coalesce IDs when merging tables in the "Join" or "Join Multiple" tools.  This functionality is available in SQL and SAS, for example.

 

This code demonstrates it.

 

data d1;

      input ID age;

      datalines;

1 45

2 36

3 77

;

run;

 

 

 

data d2;

      input ID height;

      datalines;

1 138

3 176

5 197

;

run;

 

 

 

 

proc sql;

      select      coalesce(d1.id, d2.id) as id,

                  d1.age,

                  d2.height

      from  d1

                  full join

                  d2

      on          d1.id = d2.id;

quit;

 

 

 

Could you please consider adding this option into the "Join" and "Join Multiple" tools?

 

 

0 Likes

This suggestion is particularly relevant for macros and custom tools created with the Python SDK, but I think it can apply to other tools as well.

 

When searching for tools in Alteryx, I can easily find tools I want fairly quickly.  However, I often don't know which tool category it is in, which can sometimes slow me down (it is sometimes faster/easier for me to go to the tool category, rather than search for the tool I want).

As a quick example, I just installed the Word Cloud tool that @NeilR shared here: https://community.alteryx.com/t5/Dev-Space/Python-Tool-Challenge-BUILD-a-Python-tool-and-win-a-prize... .  I was able to find the tool really easily using search once it was installed, but in order to find the tool category, I either had to unzip the .yxi file and find out where it was, or click around through the tool categories until I found it (it was in the Reporting tools, which makes a lot of sense).

 

Could we add something either to the search window or to the description/config of tools which calls out where a given tool is in the Tool Palette?

0 Likes

Hi everybody! As you can read here I had the necessity to insert a macro (publish to tableau server) at the end of a self-made app.

 

I have actually found 2 different ways to solve the problem:

 

1) Turn the macro into an app and use 2 chained apps.

2) Copy and paste tools (normal and interface) from the macro to my app.

 

Both solution work, but both require some (quite a lot to be honest) editing and re-work that actually is already done. It's kind of like to re-invent the wheel!

 

A quick way to merge 2 configuration interfaces would be really usefull.

 

 

0 Likes

When in the flow of designing a workflow, I often accidentally click on the help ? Icon on the side bar of the configuration window, thereby launching a browser window, taking me out if Alteryx and interrupting my flow. Would love to have some UX indication, perhaps a different color, that clicking on this icon will redirect the user out of Alteryx.

0 Likes

I am parsing retailer promotions and have two input strings:

1. take a further 10%
2. take an additional 10%

 

I am using the regex parse tool to parse out the discount value, using the following regex:

further|additional (\d+)%

 

When the input contains examples of both options (i.e 'further' and 'additional'), the tool only seems to parse the first one encountered.

 

E.g if I state the regex string as:

further|additional (\d+)%

 

It only parses line 1 above

 

And if I state the regex string as:

additional|further (\d+)%

 

It only parse line 2

Top Liked Authors