Alteryx Analytics Cloud Product Ideas

In a large enterprise, one of the perennial challenges is to manage changes to data over time.    The industry is moving towards a shift-left philosophy to handle this by starting to think about data contracts and contract testing.

What does this mean for Alteryx?

Well - if you look at the strategy that DBT is following, each workflow has a defined entry data contract, and a defined exit data contract - so that if anything changes you can immediately tell if you are going to break someone else's work.    This also sets you up for lineage in an important way - if you build in field and data-set level lineage from day zero - then you can look across an enterprise and answer questions like:

- If I remove this field - who will I impact downstream (e.g. other Alteryx users; Tableau dashboards etc)

- Who is using my data - so that I can talk to them about their data needs?    Who do I need to tell if my workflow fails

- has someone upstream of me changed their flow in a way that breaks me?

- Where does this field come from - looking across a series of flows and transformations (critical for regulatory requirements).

This kind of thinking is hard to add in afterwards - so it would be good to build this into the product in these early days so that this becomes a key foundational piece.

Hello all,

Sometimes, you find some messy worklow and you want to make it clean

You can align manually the tools but it would be better to have the exact same function than on Alteryx Designer on-premise :

Best regards,

Simon

When I rename a field in Alteryx - it would be valuable for Alteryx to look at all tools downstream from the select tool and say "Hey - you are using that field - do you want me to clean up the formulas etc".

A field is not just letters in a formula - a field is a logical concept / an object - so it should be relatively easy to inspect everywhere there's a dependance on this object downstream and just clean this up automatically.

This would get rid of all the painful toil of having to reconfigure tools, change formulae, change select tools etc - that can just all go away in a puff of Aidan Magic.

Hey all,

There is already an option to clean up data in the results section - but it's limited to only the cleanups that the Cleanse tool used to do in the on-prem version.

Please could you use an inspection of the field to see what cleanup may be relevant?

For example:

A_B - there's no need to offer to clean up numbers - or perhaps just visually decrease that option

    A_B - here the obvious cleanup is leading spaces

"A_B" - the obvious cleanup here is remove quotes

It seems that we can bring some smarts to this, since Alteryx AIDAN is AI enabled, to eliminate the toil of data cleansing.

Hi all,

I'm working through cloud quest 1 using the Alteryx Cloud Native experience - and it seems that there's an opportunity here to get rid of the need to know historical ways of working.

The example in this case is that there are 2 dates:

- 16-Jun-01

- 25-Dec-01

Now it seems that most people used either a RegEx or a DateTimeParse (which still uses the same specifiers since Alteryx 11 - https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#idp376621).   Additionally there doesn't seem to be a DateTimeParse tool in the platform yet in the CloudNative version.

However - given that we're living in the future now - it seems that it should be trivial to use a little AI to recognize that '16-Jun-01' is a date - and allow the user a right-click option to convert to a date.

Please can you consider doing a simpler method of cleaning up dates than forcing the user to remember the classic alteryx specifiers for dates since this is SUCH a common need

When people ask what's so great about designer desktop, one of the simple things I mention is the record count. I think this would be a great addition to designer cloud. As an example, here's a pointless workflow in designer cloud:

Seems ok, but here's the same thing in desktop:

By just looking at the picture, you can see that I messed up my join and my 780 records have ballooned to 608,400. I can also see that I didn't have any unjoined records pretty easily. Designer cloud has this record count information when you click on each tool, but I think they should display the counts on the canvas like desktop. 

Using Challenge 438 as an example, the crosstab in designer cloud needs to be dynamic for the new column names to ensure parity with desktop. Unless I'm missing something, you would need to click on the crosstab and manually reset it/add new fields anytime the data changes. Desktop would automatically pick up new fields.

Replace, ReplaceFirst, ReplaceChar and Regex_Replace in the cloud all have a limitation where arguments must be constants. Any attempt to use a column returns an error. This would a nice enhancement to have parity with Desktop. The below functions currently error out in cloud but work in desktop.

Replace(Column1,Column2, Column3)

Regex_Replace(Column1,Column2,Column3)

Could doesn't like that Column2 and Column3 are references to fields. It only works if you hardcode a string like "text". Desktop doesn't have this limitation.

Hi all,

When using the Sharepoint connector, using the Sites.Read.All permission on Service Principal does violate customer corporate security measures. The customer is requesting to implement certificate-based authentication for SharePoint Files. See ticket 00683632 for more information.

Thanks

Hello folks,

let's say it's my second greatest  deception so far! Alteryx on-premise is not perfect but it supports a lot of file format... and here, three file formats only, and three that are not performant or rich : xls, xlsx, csv

I won't make an idea by missing file format but the bare minimum seems at least to support the same file formats than on-premise (like yxdb, hyper, parquet,kml, etc...)

Best regards,

Simon

Hello,

On Alteryx Designer on-premise, we can set background and text color (and other settings...). It's very useful because it allows to have a color palette by functional or technical feature of the container. 



And as an example of the popularity of this color feature, this post on linkedin : 




Best regards,

Simon

Hello all,

I would like to move the Tool Configuration to the left instead of the default right (and save this configuration for me). 2 reasons for that : 
1/ same experience than Designer on-premise
2/ less distance to do with the mouse

(also, if the tool palette could be movable upside.... would be great)

Best regards,

Simon

Hello all,

On Alteryx Designer, you have a star (asterik) after the workflow name when it's not saved. Would be nice to have the same feature in Cloud, that's an easy, standard way to get the information.

Best regards,

Simon

Hello,

I love standards and ctrl+S is a pretty common on for the last four decades. Can we expect it to work also on Alteryx Designer Cloud please ? Even if it's in the browser, it seems possible since the guys at Dataiku managed to do it.

Best regards,

Simon

Hello,

Correct me if I'm wrong but we can't export or import a workflow. That sounds a very easy and very useful function, especially when you develop something and want to share with others users.

Best regards,

Simon

Use a linked datasets created by GCP Analytic Hub as data source in DataPrep. Detailed informations in link below:

Can I use linked dataset (created by Analytic Hub in GCP) to build flows in DataPrep? (trifacta.com)

As of now the once a user deletes the flow, the flow will not be visible to anyone, except in the database. But the flow is soft deleted in the database. So can enable the option for admins to see all the deleted flows and recover those flows if required, so that in case some one deletes the flow by mistake then admins can retrieve it by recover option. This has to be an option by check box, where they can recover those flows all at once if it is a folder. This option can also be given to folder recovery where they can recover all the flows in the folder.

I want to create a dynamic output file name in both the Trifacta UI and New Designer Cloud UI. I know that I can create a timestamp or a parameter, but it seems like the parameterization in Trifacta is static. Instead of having to manually override the parameter every run, I am wanting to grab the desired filename from a field in the dataset. This is a functionality commonly used in Desktop Designer, so I'm hoping for it to be added to the Cloud soon!

Currently there is support for parameterizing variables in custom SQL dataset in Dataprep. However it requires that the tables using this feature have the same table structure. This request is to allow this same functionality but with tables that have different table structures.

Example:

Table A

dev.animals.dogs

name | height | weight

Table B

dev.animals.cats

name| isFriendly

Would like to use a query where we have 1 custom SQL dataset where we just say

SELECT * FROM dev.animals.[typeOfAnimal]

typeOfAnimal being the parameterized variable with a default of dogs.