The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

Enable files as inputs to Alteryx that have been protected with either Azure Information Protection (AIP) or Microsoft Information Protection (MIP)

 

From: Alteryx Support <support@alteryx.com>
Sent: 04 February 2022 22:43
To: candice.darcybryant@alteryx.com
Cc: Sundaramoorthy, Nishanth-XT <nishanth.sundaramoorthy@ubs.com>; clientsvcs@alteryx.com; Bignell, Nicholas <nicholas.bignell@ubs.com>; chiggins@alteryx.com; Jaganathan, Prasanth-Ram <prasanth-ram.jaganathan@ubs.com>
Subject: [External] Case #00528349 - Fw: Azure Information Protection (AIP) or Microsoft Information Protection (MIP) [ ref:_00DE0JJZ4._5002R1On7Ru:ref ]

 

Hi Candice,

Thanks for reaching out. At this juncture, formal validation of data sources with AIP or MIP applied has not been conducted. Coincidentally, earlier this week, another user submitted an inquiry pertaining to Sensitivity Labels of MIP. They had observed that files with their organization's "Confidential" label applied were unable to be input within workflows.

Similar to password protected or encrypted files, Sensitivity Labels (and other AIP/MIP implementations) may be configured in a manner that prevents drivers (e.g. Excel) of Designer from reading the file. For any incompatibility that's observed within data sources with AIP or MIP applied, it's recommend to submit an Idea as to the Designer application supporting the scope of these implementations. Our Product and Engineering Teams actively monitor Ideas to help ensure we're delivering the best product experience to our users.

Thanks for writing in.

Best,

–Josh
Sr. Customer Support Engineer | Alteryx
 

You may be selected to participate in a short feedback survey. Any comments regarding your experience will help to ensure we're delivering the best support. Thanks!




--------------- Original Message ---------------
From: Candice D'Arcy-Bryant [candice.darcybryant@alteryx.com]
Sent: 2/4/2022 1:59 AM
To: clientsvcs@alteryx.com
Cc: nishanth.sundaramoorthy@ubs.com; nicholas.bignell@ubs.com; chiggins@alteryx.com; prasanth-ram.jaganathan@ubs.com
Subject: Fw: Azure Information Protection (AIP) or Microsoft Information Protection (MIP)


Hi Support,

 

Please could you provide the options we have for files protected with either Azure Information Protection (AIP) or Microsoft Information Protection (MIP) to be used as inputs to Alteryx?

 

 

Please let us know if you require additional information.

 

Many thanks,

 

Candice D’Arcy-Bryant  

Strategic Customer Success Manager | +44 (0) 7872 959 067 

ca?ndice.darcybryant@alteryx.com | alteryx.com

 

 

Upcoming Out of Office:

February 07-11, 21-25

 

*******************************************************************************************************************

Alteryx UK Ltd is a company registered in England and Wales with company number 08806138.  Its registered office is located at 5 New Street Square, London EC4A3TW.  

 

This email and any files transmitted are for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized use or disclosure is prohibited.  If you have received this email in error and are not an intended recipient, please contact the sender and remove it from your system.

*******************************************************************************************************************

 

 

From: Bignell, Nicholas <nicholas.bignell@ubs.com>
Sent: 03 February 2022 10:15
To: Candice D'Arcy-Bryant <candice.darcybryant@alteryx.com>
Cc: Sundaramoorthy, Nishanth-XT <nishanth.sundaramoorthy@ubs.com>; Jaganathan, Prasanth-Ram <prasanth-ram.jaganathan@ubs.com>; Craig Higgins <chiggins@alteryx.com>
Subject: RE: Azure Information Protection (AIP) or Microsoft Information Protection (MIP)

 

Hi Candice.

 

Seems there is an internal programme to implement this.

 

I have been contacted by three teams so far in the IB,  IB FX trading and IB Operations and IB Risk management.

 

 

In terms of potential impact it could be bank wide, but seems to be starting with the IB since November last year.

 

The program site (called DRM internally) states:

 

The Digital Rights Management (DRM) solution helps us manage data more effectively by putting a 'digital lock' on highly sensitive files. This means that even when a file is lost by accident, the external person who finds it cannot access its contents. These DRM classified and protected files can still be accessed and edited internally by UBS employees.

After a file has been classified according to its level of sensitivity DRM will automatically encrypt files if they are classified as 'confidential' or 'strictly confidential'. The classification and protection of a file can be set manually, or is automatically set for downloads of reports from applications that contain sensitive information or for users that have access to CID from specific applications (see details in the DRM guideline).

DRM is available globally in UBS.

 

Thanks Nick

 

From: Candice D'Arcy-Bryant <candice.darcybryant@alteryx.com>
Sent: 03 February 2022 09:32
To: Bignell, Nicholas <nicholas.bignell@ubs.com>
Cc: Sundaramoorthy, Nishanth-XT <nishanth.sundaramoorthy@ubs.com>; Jaganathan, Prasanth-Ram <prasanth-ram.jaganathan@ubs.com>; Craig Higgins <chiggins@alteryx.com>
Subject: [External] Re: Azure Information Protection (AIP) or Microsoft Information Protection (MIP)

 

Hi Nick,

 

Yes, I'm enquiring internally and will get back to you as soon as I have some information.

 

In the meantime, it would be good to understand:

  • Who is impacted by this issue?
  • What the impact is?
  • Where in the business this is being felt the most?
  • How many users / workflows are affected by this?
  • When did this first start to affect users / workflows?

Many thanks,

 

Candice D’Arcy-Bryant  

Strategic Customer Success Manager | +44 (0) 7872 959 067 

ca?ndice.darcybryant@alteryx.com | alteryx.com

 

Upcoming Out of Office:

February 07-11, 21-25

 

*******************************************************************************************************************

Alteryx UK Ltd is a company registered in England and Wales with company number 08806138.  Its registered office is located at 5 New Street Square, London EC4A3TW.  

 

This email and any files transmitted are for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized use or disclosure is prohibited.  If you have received this email in error and are not an intended recipient, please contact the sender and remove it from your system.

*******************************************************************************************************************

 

From: Bignell, Nicholas <nicholas.bignell@ubs.com>
Sent: 03 February 2022 08:48
To: Candice D'Arcy-Bryant <candice.darcybryant@alteryx.com>
Cc: Sundaramoorthy, Nishanth-XT <nishanth.sundaramoorthy@ubs.com>; Jaganathan, Prasanth-Ram <prasanth-ram.jaganathan@ubs.com>
Subject: Azure Information Protection (AIP) or Microsoft Information Protection (MIP)

 

Hi Candice

 

Can you investigate what options we have for users that want use files as inputs to Alteryx that have been protected with either Azure Information Protection (AIP) or Microsoft Information Protection (MIP)

 

Thanks Nick



ref:_00DE0JJZ4._5002R1On7Ru:ref

Sometimes, when you change the system settings on Alteryx Designer, you get this annoying message :

Error: "Settings Validation Error" Alteryx Service failed to initialize, likely due to inconsistent RuntimeSettings.xml file: Unable to start Queue service, insufficient license

 

simonaubert_bd_0-1644002073290.png

well, well, well...

I found the solution to this page https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Settings-Validation-Error-when-usin...


"Under Environment Setup Type, you must select "Designer Only" if only Designer is licensed"


Maybe instead of the current message, Alteryx can check the licence and help with a "you must choose Designer only option ath the beginning because only Designer is licensed".

Best regards,

Simon

If an Output Data tool fails, there are frequently other processes within the workflow that depend on the status (success|failure) of the output. I find myself having to build a macro or some other overengineered method to validate the status of the Output Data tool. Instead, please put an output anchor on the tool. Then, if there's an error, no downstream process will run and this will greatly simplify error handling. Thank you.

I annotate every single tool, every single time. I treat a workflow like documentation. It would be helpful to use markdown in the annotations.

0 Likes

I love the macro indicator. It is not obtrusive and over the top. Can I have something similar for tools that are available to be cached? I don't want to hunt and right-click on tools to see if the cache option is greyed out of the context menu. Please just put a wedge or some other shape on the tools that can be cached.

0 Likes

In older versions, I could delete the text of an annotation. It didn't matter if I wrote it or if it was autogenerated. Now, I cannot remove the text of the annotation. Yes, I know that I can hide the annotation of that tool. I want to delete the text. I have to select all the text and replace it with a space. I don't know why this functionality changed. Please change it back.

Hello all,

I just love the DCM feature. However, you have to enable it manually in system settings after the install or the update.

I don't think there is a good reason for that and it would save time to enable it by default.

simonaubert_bd_0-1643921496674.png

 

Best regards,

Simon

 

Under the Runtime setting, there is an existing option to "Disable All Tools that Write Output". This is incredibly useful when developing workflows when you don't want to overwrite existing files.

 

But this option doesn't disable all outputs, like Publishing to Tableau! 

 

I suggest adding the option to disable ALL kinds of outputs, uploads, and publishing (except possibly logging and caching).

Hello,

please remove the hard limit of 5 output files from the Python tool, if possible.

It would be very helpful for the user to forward any amount of tables in any format with different columns each.

 

Best regards,

0 Likes

Hello,

the Python scripts sometimes get lost or updated when the user forgets to save his/her Jupyter notebook.

 

Please enhance.

 

Thanks and best regards,

Fabian Rudolf

Current issue with Alteryx Software is that each time an Alteryx file is opened it tries to establish a connection with Database or File. This results in:

 

  1. Lockout situations when Enterprise password is changed
  2. No ability to share Alteryx Workflows with Colleagues (when they open it will have author of files credentials resulting in locking out author)
  3. Countless phone calls with Enterprise IT to reset password.

 

Should be a feature/enhancement that we can either toggle on/off whether we want our flows to establish connection with data source/file when we first open the Alteryx file.  This toggle would save countless time and effort from developers when working with secured connections that require credentials.  

Hello! I'm just wanting to highlight a couple of small issues I've found when trying to use the TS Covariate Forecast.

1. The example workflow does not open. This has been tested on multiple machines with different users. Right clicking the macro allows for the option 'Open Example Workflow':

TheOC_0-1643812709573.png
However the button does not work/do anything. It is listed as a tool with a 'one tool example' (https://help.alteryx.com/20213/designer/sample-workflows-designer) so i would expect this to work.

2. Fix left/right labelling of input anchors. Currently the anchors are labelled incorrectly (compared with the join tool):

TheOC_1-1643812782521.png


This can make things confusing when looking at documentation/advice on the tool, in which it is described as the left/right inputs.

Thanks!
TheOC

A few suggestions that I think can improve the Sharepoint Files Output Tool:

 

  1. Maybe I'm missing it, but I cannot see how you can delete a file from the output list once you've added it:
    1. Joe_Lipski_1-1643795491697.png

       


       

  2. Have the write headers output checkbox ticked by default as I expect this is the more common expectation:
    1. Joe_Lipski_2-1643795558506.png

       

  3. Take the file extension by default based on the users selection in the Options tab as I shouldn't have to write .xlsx for the extension:
    1. Joe_Lipski_3-1643795713015.png

       

    2. Joe_Lipski_4-1643795723518.png

       

@VojtechT 

 

Reporting automation capability is absolutely a great feature that puts Alteryx far ahead its competitors.

 

Unfortunately, Alteryx reporting tools start to become old fashioned in terms of : 

  • look & feel
  • charts library
  • charts configuration

 

It would be great if Alteryx could redesigned its reporting tools in order to allow the generation of smashing, flashy, modern visualizations mixing nice charts and maps.

 

Many thanks !

Hello,

 

I discussed with Alteryx support via email and they informed to post on here for a possible enhancement to Alteryx.

 

The issue I'm facing is that in raw data coming from SAP, the raw column names have carriage returns in them.

In Alteryx, in the display window, it will just show the first line before the carriage return and not the rest of the text, even though the text is all in one cell in Excel.

In Alteryx, I also tried exporting the file and it will just show the first line before the carriage return and not the rest of the text, even though the text is all in one cell in Excel.

However, when using any tools, the full column names are displayed. 

An enhancement would be for the display window and export tool to have the full column names displayed.

0 Likes

A quite basic request but still really frustrating when working with this component.

Can you please allow the resizing of the window in the List for Calgary input tool ? 

 

Please see an example attached. 

In the formula tool, you can use a question constant when working with App. This is really cool.

However, the answer provided in the workspace to test, is not visible in the formula preview.

I think this would be a not too big change but a quite nice improvement. 

 

Add ability to lock comment boxes size, shape, position (send to back), location on the canvas. This would allow a developer to use a template when creating workflow without accidently selecting and/or adjusting these attributes. It will also allow a user to put a tool over the top of the comment box without fear of messing up the visual display of the workflow or it getting hidden underneath the comment box.

 

I've obviously been doing lots of work with APIs for this to be my second idea posted today which relates to an improved based on recent work with APIs, but I also believe this is wider reaching.

 

I've been using Alteryx now for over 4 years and always assumed implicit behaviour of the select tool, so would add a select tool as best practice into a workflow after input tools to catch any data type issues. However I discovered that only fields where you either change the data type, length or field name result in that behaviour being configured and subsequently ensured. I discovered this as part of API development where I had an input field which was a string e.g. 01777777. Placing a select tool after this shows this is a string data type, however if the input was changed to 11777777 the select tool changes to a numeric data type. Therefore downstream formulas such as concatenating two strings would fail.

 

The workaround to this is to change the select tool to string:forced, which is fine when you know about it, but I suspect that a large majority of users don't. Plus if you have something like 2022-01-26 which is recognised initially as a string, then the forced option will be string:forced, however if you wanted it to be date:forced you need to add a first select tool to change to date, and a second select tool to change to string:forced.

 

Therefore my suggestion is to add a checkbox option in the select tool to Force all field types, which would update the xml of the tool and therefore ensure what I currently assume would be implicit behaviour is actually implemented.

 

 

When working with APIs it is quite common to use the JSON parse tool to parse out the download data which has been returned from the API. However the JSON data may be missing key:value pairs as they are not in the response. This causes issues with downstream tools where there are missing fields. The current workaround for this is to use either the Crew macro Ensure fields, or union on a text input file to force the missing fields downstream.

 

The issue with this is:

1) Users may not be aware of the requirement to ensure fields are present

2) You need to know the names of all the fields to include in the ensure fields macro

 

Therefore the feature request is to add an option to the JSON parse tool to add the model schema as an input.

 

For example with the UK companies house API, to get a list of all the directors at a company the model schema is

 

 

{
    "active_count": "integer",
    "etag": "string",
    "items": [
        {
            "address": {
                "address_line_1": "string",
                "address_line_2": "string",
                "care_of": "string",
                "country": "string",
                "locality": "string",
                "po_box": "string",
                "postal_code": "string",
                "premises": "string",
                "region": "string"
            },
            "appointed_on": "date",
            "country_of_residence": "string",
            "date_of_birth": {
                "day": "integer",
                "month": "integer",
                "year": "integer"
            },
            "former_names": [
                {
                    "forenames": "string",
                    "surname": "string"
                }
            ],
            "identification": {
                "identification_type": "string",
                "legal_authority": "string",
                "legal_form": "string",
                "place_registered": "string",
                "registration_number": "string"
            },
            "links": {
                "officer": {
                    "appointments": "string"
                },
                "self": "string"
            },
            "name": "string",
            "nationality": "string",
            "occupation": "string",
            "officer_role": "string",
            "resigned_on": "date"
        }
    ],
    "items_per_page": "integer",
    "kind": "string",
    "links": {
        "self": "string"
    },
    "resigned_count": "integer",
    "start_index": "integer",
    "total_results": "integer"
}

 

 

But fields such as "resigned_on" are not always present in the data if there are no directors who have resigned. Therefore to avoid a user missing the requirement for unidentified fields needing to be added, if there was an optional input which took the model schema and therefore created the missing fields would greatly improve the API development process and minimise future errors being encountered once a workflow is in production.

Top Liked Authors