Alteryx Analytics Cloud Product Ideas

Please allow connections to be created from Trifacta to SharePoint online using SSO authentication, just like for Azure SQL/DWH.

It would be great if you can expand the metadata selection to not be limited to 2 elements (row number and file path) but could potentially add the date timestamp (e.g. $datecreated) to be used in the recipes.

We need the ability the create folders underneath the plans. We can create folders underneath flows, but not underneath plans. Additionally, having the ability to create sub folders inside of these parent flow and plan folders is needed. Hard to organize flows and plans without the ability to put them in categories (folders) and subcategories (sub folders) when you approach hundreds of plans and flows.

In order to monitor the status of the plan that has been running several different flows inside, in my case it is around 300, I send the HTTP request to Datadog to display the result of failed and success on a dashboard. The problem is, DATADOG understands only epoch timestamp and not the datetime value. Right now we cannot convert the timestamp into epoch. I was thinking of approaching this problem in the following ways:

1) Having a pre-request script

2) Creating dynamic parameters in Dataprep instead of using a fixed value, that can be used further in the HTTP request body

3) This is just the turnaround - Creating a table that stores the flow name and timestamp in it, and we are supposed to use this table in a plan every time we are running a flow. But this is not the right way. It will work but it is waste of time as we will end up creating separate tables like this one for each flow.

Current syntax for WORKDAY function is workday(date1,numDays,[array_holiday]), and the array_holiday can't be a column a table, for example when there's any unpredictable non-trading days like Typhoon weather, we always need to go and change the public holidays in recipe, would prefer if the holidays can be from a column in a table that we can just import and update the table when needed.

Allow for more then 1 job to be deleted at a time.

Current NIST/NSA standard is SHA-2.

As a data wrangler, I would like to be able to hash a column's data using the SHA-256 hashing algorithm.

Create a function in the Formula tool to pull Customer Managed Telemetry data like User ID, Job ID, and Start and End Runtime when running the workflow, instead of navigating to the Jobs tab separately and forgo matching the Job ID.

I'm happy to see there is now a DateTimeNowPrecise function, but you still have to convert this to a datetime with a DateTime tool, then get the min and max of this field to determine runtime.

I started migrating some processes from Desktop to Cloud, but I miss the email customize sending functionality in Cloud. Is it possible?

I would like to send a customized email after a successful execution, but I couldn't find the option to customize the email or attach a file.

If it is not possible, are there plans to implement this soon?

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

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.

I would like the ability to specify a billing project for BigQuery as part of run options. Currently, data queried from BigQuery is associated to the project from which a Dataprep flow is run with no way to change it. For customers we work with in a multi-project environment, they need the flexibility to align queries to specific projects for purposes of cost and usage attribution.

Additionally, for customers on flat-rate BigQuery pricing, a selectable billing project will allow users to move queries to projects under different reservations for workload balancing and/or performance tuning.

We can migrate flows from one environment to other environment using Trifacta APIs.

Export and Import the flow from source to target.

Rename the flow.

Share flow with appropriate user according to environment.

Change the input and output of the flow.

Create a connector to Mavenlink.

We at Grupo Boticário, who currently have 13k Dataprep licenses and close to the official launch internally, have noticed a recurring request for a translation of the tool. Bearing in mind that it will be an enabler for more users to use in their day-to-day work, I would like to formalize and reinforce the importance of our request for translation into Brazilian Portuguese as well as a forecast of this improvement.

Currently, If there is use-case that the data needs to brought from tables resting in different databases of a same cluster. We have to create n connections for n databases.

But being in same cluster, one should be able to access different databases with a single connection otherwise the connection list gets long and messy.

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.

Users to be able to create multiple connections to data lake. Currently user needs to add new data lake path and browse it in order to import data