Alteryx Designer Desktop Ideas

Add the ability in the select records tool to use formulas not just record numbers. 

Many of today's APIs, like MS Graph, won't or can't return more than a few hundred rows of JSON data. Usually, the metadata returned will include a complete URL for the NEXT set of data.

Example:  https://graph.microsoft.com/v1.0/devices?$count=true&$top=999&$filter=(startswith(operatingSystem,'W...') or startswith(operatingSystem,'Mac')) and (approximateLastSignInDateTime ge 2022-09-25T12:00:00Z)

This will require that the "Encode URL" checkbox in the download tool be checked, and the metadata "nextLevel" output will have the same URL plus a $skiptoken=xxxxx value.  That "nextLevel" url is what you need to get the next set of rows.

The only way to do this effectively is an Iterative Macro . 

Now, your download tool is "encode URL" checked, BUT the next url in the metadata is already URL Encoded . . . so it will break, badly, when using the nextLevel metadata value as the iterative item.

So, long story short, we need to DECODE the url in the nextLevel metadata before it reaches the Iterative Output point . . . but no such tool exists.

I've made a little macro to decode a url, but I am no expert. Running the url through a Find Replace tool against a table of ASCII replacements pulled from w3school.com probably isn't a good answer.

We need a proper tool from Alteryx!

Someone suggested I use the Formula UrlEncode ability . . .

Unfortunately, the Formula UrlEncode does NOT work. It encodes things based upon a straight ASCII conversion table, and therefore it encodes things like ? and $ when it should not.  Whoever is responsible for that code in the formula tool needs to re-visit it.

Base URL: https://graph.microsoft.com/v1.0/devices?$count=true&$top=999&$filter=(startswith(operatingSystem,'W...') or startswith(operatingSystem,'Mac')) and (approximateLastSignInDateTime ge 2022-09-25T12:00:00Z)

Correct Encoding: 

HI, 

Not sure if this Idea was already posted (I was not able to find an answer), but let me try to explain.

When I am using Mongo DB Input tool to query AlteryxService Mongo DB (in order to identify issues on the Gallery) I have to extract all data from Collection AS_Result.

The problem is that here we have huge amount of data and extracting and then parsing _ServiceData_ (blob) consume time and system resources.

This solution I am proposing is to add Sorting option to Mongo input tool. Simple choice ASC or DESC order. 

Thanks to that I can extract in example last 200 records and do my investigation instead of extracting everything 

In addition it will be much easier to estimate daily workload and extract (via scheduler) only this amount of data we need to analyze every day ad load results to external BD.

Thanks,

Sebastian 

When you first pull the the download tool onto the workspace the password on the connection Tab is already populated plus you don't see a cursor when you click in the box!  you only see a cursor if click in the box and then type.  Can you please change this so it behaves the same as the the username box and leave it blank?

Idea:

Similar to the Formula Tool how it shows an example based on the first record. Could the Filter Tool have a example based on the first record showing how the formula in the filter would handle that record? It would either show in an example field for the true sample or false sample based on the criteria. I feel this would be very useful for more complex formulas such as AND/OR.

Ex.

Filter Formula: [Count] <= 1

True Sample: [Blank]

False Sample: 4 (Value of first record which was filtered from [Count])

I was working on the file and there are multiple sheets need to be pulled from one excel file. I was not sure how we can give one source of information and pull multiple sheet from one source as per the requirement. So wanted to submit this idea to create a toll which can pull any sheet(s) from one input tool as per requirement.

When you import a csv file,  I sometimes use a "TAB" as delimiter. In section 5 Delimiters I want that as an option.

I have learned that it is possible to wright "\t" but a normal choice would bed nice.

Currently, the Parse Address tool cannot parse a field where the entire address, including so-called "last line" information (city/state/zip), is in all in the same field - it can only parse a street address contained in one field and last line information contained in a second field.  Can this tool be enhanced so that it can parse a full address in a single field?

Need a tool that can remove nulls in 2 ways:

1. Remove rows with null values

2. Remove columns with null values

Thinking you're able to open the config file like you might a macro. You pull it open, adjust/modify it , you resave it. 

Save/Load Unique Key Tool Configuration – similar to saving/loading other tools configs  (ie: select, join, append, etc)

Alteryx can add more advanced machine learning capabilities, such as deep learning and neural networks, to its existing set of predictive modeling tools. This will allow users to perform more complex and accurate analyses, and enable them to tackle more sophisticated machine learning problems. For example, Alteryx can add support for deep learning frameworks like TensorFlow and Keras, which will allow users to use pre-trained models or create their own models for image and natural language processing.

Alteryx can improve the data connectivity options by adding more built-in connectors to various data sources such as big data platforms, cloud-based services, and IoT devices. This will enable users to easily access and import data from a wider range of sources, without the need for complex coding or manual data preparation. For example, Alteryx can add connectors to popular big data platforms like Hadoop and Spark, or cloud-based services like AWS and Azure, which will allow users to easily import data from these platforms into Alteryx for analysis.

For the summary tool, allow for the field data definition type of the output.  

1. Schedules에 등록된 workflows 목록에서 여러개를 선택해서 한번에 once schedule을 등록할 수 있는 기능(button)이 있었으면 좋겠습니다. 많은 workflows 등록하고 관리하는 경우에, 네트워크 장애 등으로 실행이 제대로 되지 않았을 경우 한꺼번에 schedules를 추가하고 실행 해야하는데 현재로서는 하나하나 Designer에서 열어서 실행시키거나 schedule에 다시 각각 등록하는 수밖에 없습니다. 일괄적으로 실행시킬 수 있는 기능이 있다면 관리가 매우 편해질 것입니다.

2. open api를 이용하여 데이터를 download 할 경우, 웹 사이트에 따라 안되는 경우가 많습니다. 안되면 결국 python을 이용해서 데이터를 download 하는데요, Designer의 download를 이용해서 데이터를 받을 수 있으면 좋겠습니다. 이미 많은 이슈가 있는 것으로 알고있습니다.

I would like to Alteyx making a New Warning（Int type）

If a decimal point occurs during division of Int type data, the digits are truncated.

example
1/3 = 0.333333, but
If it is of type Int, it will be displayed as 0.

I know that the Int type is defined as an integer, but
I would like to Alteryx making a warning if the operation does not result in an integer.

Then we should be able to detect errors.

Thanks！

Very beneficial will be adding extra row in Input tool (while we importing CSV) where we can define escape character. This functionality will help to avoid errors that currently occur when importing such files.

let’s suppose I am working a bank accounts and I do want to make sure I end up with minimum required information hence I would pull the template provided and work backward from there to manipulate the data. The template would include as well a predefined tableau output for example! 

Currently if we have to read multiple files though dynamic input, most of the times the files error out due to Schema error and we have to create a batch macro, if there is an option added wherein by right clicking dynamic input it gives and option to create batch macro, a simple batch macro with control parameter, Input tool and macro-output, this will save time in recreating the macro every time