Alteryx Designer Desktop Ideas

Hello,

Here is the proposal about an issue that I face frequently at work.

Problem Statement -

Frequent failure of workflows that have either been scheduled or run manually on server because the excel input file is sometimes open by another user or someone forgot to close the file before going out of office or some other reason. 

Proposed Solution - 

The Input/Dynamic Input tools to have the ability to read excel files even when it is open so that the workflows do not fail which will have a huge impact in terms of time savings and will avoid regular monitoring of the scheduled workflows.

Hello,

As of today, DCM is great to store credentials. But once we want to dive deeper in technicity, like using macros or Applications, it's really bad. One of the things I hate is that we can't retrieve any informations from the DCM connection, just the id. Not good for logs, really bad for understanding and have some conditional logic related to connection type or name.

Here an example

Nice, I managed to retrieve an id but I have no idea of what it means : what kind of connection? what's name?

Best regards,

Simon

Hello,

Could there be a way to explore the details of the results window by double-clicking on a value of the Browser profile?

Basically if the profile of a field in the Browser tells me that there are x records meeting that value, could they be selected by double-clicking on that value in the profile? A bit like when you explore the underpinning rows in a pivot table in Excel; if you want to see which records meet the criteria, you double-click on the value.

For example clicking twice either on the label or the count and the specific records would show.

In a similar vein to the forthcoming enhancement of being able to disable a specific output tool, my idea is to have the inverse where you can globally disable all outputs and then enable specific ones only. This should help reduce the number of clicks required/avoid workarounds using containers to obtain this functionality and allow users to be very specific in which outputs run and don't run as required.

Currently it's possible to use the Output tool to output to either a sheet, a place in a sheet or a named range in Excel, but it is not possible to output to a preformatted excel table - it would be really good if the output tool had an option to output to [Table1] in an Excel workbook for example. This enhancement would be incredibly helpful for reporting purposes.

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

Hello all,

as of today, a join in-db can only be done with an equal operator.

Example : table1.customer_id = table2.customer_id

It's sufficient most of the time. However, sometimes, you need to perform another kind of join operation, (especially with calendar, period_table, etc).

Here an example of clause you can find in existing sql

inner join calendar on calendar.id_year_month between fact.start_period and fact.end_period

helping to solve that case :

(the turnaround I use to day being : I make a full cartesian product with a join on 1=1 and then I filter the lines for the between)

or <,>, .... et caetera.

It can very useful to solve the most difficult issues. Note that a product like Tableau already offers this feature.

Best regards,

Simon

It would be wonderful for Alteryx to be able to connect to and query OData feeds natively, rather than using a 3rd-party driver or custom macro.   

OData querying is supported by quite a few familiar products, including Excel and PowerBI, SSIS/SSRS, FME Safe, Tableau, and many others. And the protocol is used to publish feeds from Microsoft Dynamics and Sharepoint, as well as many of the 10,000 publically available government datasets with API's (esp. those hosted by Socrata)   

I didn't see it as in the Idea section, but questions and workarounds have been discussed in the community a few times (11/15, 3/18, 4/18), and suggestions seem to be just to buy the $400-600 ODBC driver from CDATA (or ZappySys), or I could use a VBA script in Excel trigger a refresh, or create my own Alteryx connector macro (great series btw, though most was beyond my understanding!) 

While not opposed paying, kludging, or learning to program, they're just one more thing to build/buy, install, maintain, and break at the most inconvenient time 🙂

Thanks,
Chadd

OData Overview:

OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests.  OData RESTful APIs are easy to consume. The OData metadata, a machine-readable description of the data model of the APIs, enables the creation of powerful generic client proxies and tools.

More info at at http://odata.org

Hello all,


As you all know, you can use API with the Alteryx Download tool. However, this tool is not that easy to configure.
On the other hand, the API world use a lot tools such as Postman  or Bruno (an open source clone) which allows easy test, debug... I use it everytime I had to work on a rest API and then I try to translate it to the final tool (such as the Alteryx Download tool). Both tools offer "collection", a set of request, and also environment configuration. Here are some examples on the project I'm working on :

And you can even get some code



I would like to leverage those collections in my download tool configuration, that would be quite easier to use !

Best regards,

Simon

Hello,

I think the option Overwrite File (Remove) shouldn't throw an error if the file is not present

Or, I don't know, make 2 options : one with fail if file is missing, the other to not fail.

This idea is the same than https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Overwrite-Table-for-output-write-indb-should... but for files.

Best regards,

Simon

From Wikipedia :

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object. This pre-established query command is kept in the database dictionary. Unlike ordinary base tables in a relational database, a view does not form part of the physical schema: as a result set, it is a virtual table computed or collated dynamically from data in the database when access to that view is requested. Changes applied to the data in a relevant underlying table are reflected in the data shown in subsequent invocations of the view. In some NoSQL databases, views are the only way to query data.

Views can provide advantages over tables:

    Views can represent a subset of the data contained in a table. Consequently, a view can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view, while denied access to the rest of the base table.
    Views can join and simplify multiple tables into a single virtual table.
    Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data.
    Views can hide the complexity of data. For example, a view could appear as Sales2000 or Sales2001, transparently partitioning the actual underlying table.
    Views take very little space to store; the database contains only the definition of a view, not a copy of all the data that it presents.
    Depending on the SQL engine used, views can provide extra security.

I would like to create a view instead of a table.

Hey all,

The join tool currently does not allow case-insensitive joins, but the find/replace tool does.    Additionally- even if both sides are identical, the join tool will not join "Sean's house" to "Sean's house" because of the non-letter character in the middle.    Finally - if one side is a string(2), and the other is a vString(200) - even if you have a single identical character on both sides you get uncertain outcomes unless you force the type

Please could you consider amending the join tool to include 3 new options or capabilities:

- Case insensitive join

- Allow full Unicode character set in join

- Full match across text types (irrespective of string size) - this would allow a string(2) value to match to a string(100) value as long as the string(100) value only has the same 2 characters in it as the string(2) value

That would remove a load of work from every text-join that's being done on every canvas we do.

Thank you 

Sean

Currently Alteryx does not support writing to SharePoint document libraries.

However there are success sometimes but not at other times.

Please see attachment where we ran into an issue.

See this link for additional information.

https://community.alteryx.com/t5/Data-Sources/Connect-to-and-Publish-Back-to-SharePoint-Online/m-p/4...

We need official support for reading and writing to SharePoint document libraries.

It's an important Output target, and will becoming more so, as Alteryx enhances its reporting capabilities.

Hello,

SQLite is :

-free

-open source

-easy to use
-widely used

https://en.wikipedia.org/wiki/SQLite

It also works well with Alteryx input or output tool. 🙂

However, I think a InDB SQLite would be great, especially for learning purpose : you don't have to install anything, so it's really easy to implement.

Best regards,

Simon

Right now we can create Tableau extract files (.tde), but cannot read them into Alteryx -- this limits the partnership of these two companies.
Please add the functionality to import .tde files,
Best,
Jeremy

The bak file that is automatically created (and re-created if deleted) really clutters up our folders.

Please allow us to either turn it off, or specify a different location to hold our back up files.

Thanks

Currently - if someone has accidentally kept an excel file open on their desktop, Alteryx will fail to load this flow.

However, it would make more sense to open this file without read-lock as a dirty-read (equivalent of "Read Uncommtted").

This may require some interaction with Microsoft but would be worth pursuing because it prevents / eliminates an entire category of needless canvas errors.

Hello all,

DuckDB is a new project of embeddable database by the team behind MonetDB. From what I understand, it's like a SQLite database but for analytics (columnar-vectorized query execution engine on a single file). And of course it's open-source and free.

More info on their website : https://duckdb.org/

Best regards,

Simon

• Have anyone experienced the same error?
• If yes, is there any workaround to connect with M365?