Alteryx Designer Desktop Ideas

Hello,

I am currently testing whether my company could use OneDrive as repository for all of our new projects.

Example path:

C:\Users\MyUserNameFolder\CommonCompanyOnedriveFolder\SpecificTeamsDirectoryFolder\

"C:\Users\UserName" is dynamically changed part of all dependecies located on our Onedrive TEAMS folder. In order to dynamicaly define that part for all of our input/outputs we have to utilize GetEnvironmentVariable("USERPROFILE") function at all input/output routes.

Problem lies with macros. Although I can use %TEMP% user variable to define paths for all macros, I wasn't able to replicate that with %USERPROFILE%

<EngineSettings Macro="%TEMP%\CommonCompanyOnedriveFolder\SpecificTeamsDirectoryFolder\OneDriveTesting\testingmacro.yxmc" /> works

<EngineSettings Macro="%USERPROFILE%\CommonCompanyOnedriveFolder\SpecificTeamsDirectoryFolder\OneDriveTesting\testingmacro.yxmc" /> doesn’t

Could you please enable all user/system variables to be detected at runtime (even custom ones)?

This would enable Alteryx Designer to support cloud based storage folder natively, as filepaths for all OneDrive based files stored locally would be dynamically changed across users with a particular workflow opened.

Alteryx version 2020.4

The find and replace feature is great. Unfortunately, I was unpleasantly surprised to learn the hard way that workflow events are outside of its reach. Please expand to include the entire workflow to act on everything opening the xml in notepad could find and replace. The following demonstrates the omission...

On left side I search for the string “v022”

Below that shows zero matches

In the open event box near the center, “v022” appears in the command box

The occurrence in event command box should appear as a match, but does not.

See this community link for context:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/There-is-no-option-to-clear-the-In-...

tl;dr: 

An option to clear the In-DB File History is not available in the Designer's GUI. If this feature is required, it's recommended to open an Idea on the Alteryx Community to submit an enhancement request.

Please implement this as an idea; I need to clear some In-DB connections that are no longer valid and in a managed environment, accessing the registry is laughable.

Thank you!

Would like to be able to connect to the Stibo STEP system/database as a Data Source. Some people have the Stibo server on-premise while others have it hosted in Amazon (AWS).

Not sure what else I could provide at this point for further details.

Hello Alteryx Gurus - 

I've got some workflows that run daily, but there are times, depending on the breaks, wherein I don't get any data from one of my data sources.  Which is actually fine, nobody did Job X today.  But it makes Alteryx puke out and I get an error message emailed to me.  Ultimately, I've got to hop into the rather voluminous log entries to determine if this was a data stream not initialized / was empty error, or something else that I actually need to care about. 

That being said, in the coding realm, it is relatively simple to look for specific flavors of exceptions and then just eat them without notifying people.  So, why not add something to the runtime / events panel for emailing at error time to allow for ignoring data stream not initialized errors?  In this way, I could get notified when there is a real error I need to pay attention to, and not get notified when there is no new data, which isn't really that big a deal.  

Thank you for attending my TED talk on enhanced error reporting and exception classification capabilities.

I guess it's better if the current column filter feature would cover the entire data set not just the partial results. This would be useful especially if after you run the complicated workflow and you just want to test the data particular nodes in the canvass. 

It really would be great if Alteryx supports the 'set' data type.

I often have situations where I really wish I could make a field with a data type of "set".

For example, I have a table of pets owned by each person.

The "Pets" Field would be perfect if it could be processed as a "set" type.

(I sort the pet values in alphabetical order, and concatenate the string values using the summarize tool. This is the best I could think of)

Hello Alteryx, Please fix Salesforce Input and Output tools. 

The input tool has a lot of issues with Login , , Custom SQL, Json issues, Machine Encryption, and saving to the gallery , . 

Unable to use Crew macros with Salesforce input Workflows etc.... there is a lot of post's with all the issues with Salesforce V.1 Versions. 

The performance profile option outputs a list into the results window. It is difficult to check the tools and continuously scan back to the profile. Make it easy! Put the times and percentages in the connection progress tooltips of all the tools.

To measure the computational complexity of an Alteryx workflow, you need a unit of measure. Because the execution time depends on hardware performance, execution time is not suitable for comparison on different PC's. I temporarily named this to Alteryx Calculation Score (ACS).

ACS is useful for:
1. For troubleshooting purposes, I want to compare my workflow ACS and execution time between my PC and another PC. If the workflow overflow PC's memory, ACS is same but execution time goes worse.
2. I would like to compare the workflow ACS for Weekly Challenge with other people's workflows.
3. When you want to choose the suitable Alteryx tool for your purpose, ACS will be good guide.

ACS is roughly proportional to execution time without DISK and network I / O. Each Alteryx tool has a fixed ACS value because its computational cost depends on the data and settings.

I believe ACS will improve the performance of Alteryx and its workflow.

I would like to know the run time user for workflows in Gallery. Possibly changing the run time username in the gallery. I know we could include the credentials at workflow save to gallery but that means I have to open the workflow and change the credentials.Also, we could change the worker process to be run with certain credentials I will have to be admin to be able to do edit worker process setup.

Thanks

During development it seems the syntax checker or whatever process runs behind the scenes after a tool is modified reviews the full workflow. 

Ex - Just from observation if I modify the file name in an output tool I don't see why it would rerun the full syntax check process.

This reduce the time waiting to continue development.

We have to run the full workflow at a time, if you can please think of something like partial running of the workflow and also while designing the flow if we add new tools, we have to run the entire flow again. 
Why can't it hold the intermediate data to avoid re-running the entire code.

Hey team,

I like the profiling function in the browser. Unfortunately, there is not built-in export function. Would it be possible to implement a function to export the profiling results into excel and PDF?

Thanks,

Christoph

This is a question which is somehow in between Designer and Gallery ideas.

When saving a workflow to the Gallery, the user can select the Assets (elements which are also copied to the Gallery). The point in time during the save process is a bit questionable from my perspective.

Often, I develop workflows locally until they reach a state in which I want to move them to the Gallery so that they can be included in Schedules or be made available to other users. I would like to be able to select which macros or datafiles are copied to the Gallery as well much earlier in the development process. From my perspective, it would be great if the user could set the Assets settings in the "Workflow Dependencies" window as well. I propose 3 possible values for each element (macro or data file):

• "Auto" → decide on asset when saving the workflow to the Gallery (current behaviour)
• "Yes" → Copy this element as asset in the Gallery
• "No" → Do not copy this element to the Gallery 
• "N/A" → The question does not apply to this row (e.g., directory)

It could look like this:

When I open I'd workflow, I'd like the option click on "something" to see content previous created for the workflow.  The content I'd use most frequently is:  How was the INPUT data obtained?  ALL of the Alteryx workflows I will be creating with my current employer will require some level of pre-build of the data sources.  I would like to document the pre-build requirements (could be pages of text, so "comments" aren't optimal) and be able to ask for them as needed.

Optimally, this feature would accept .docx, .pdf and other standard formats.  Another option would be to support a URL that would link me to the content.  For my purposes, this would be even more advantageous as all of our knowledge content is on-line.

One of things I like to do is select a bunch of tools and to see the collective performance of particular part of a workflow. It would be super cool if these stats were aggregated. 

I could imagine then you could run alternative solutions side by side and then just select the tools involved to compare.

Currently, Cache and Run Workflow cannot be used if there's a second branch of data which goes around the tool which you want to cache. This slows down intermediate runs especially in complex workflows with a lot of inter-dependencies.

For example:

If you want to cache at the formula "Do something", Alteryx will not allow this because a single temporary cache file at this tool will not be sufficient:

My suggestion is that Alteryx allows multiple cache files for one single cache event. In this case:

Proposed process:

1. Run the cache run from the initial source(s) of data (here the Text Input tool) via all tools needed to produce the output of the selected tool (here Formula "Do something"). In this case: Text Input, left Select, Formula.
2. Produce a cache file for every tool which has a connection towards outside of the direct tool chain. In this case: Cache file 2 (as Alteryx does it today), Cache file 1 (new behaviour)

This way, I could use Cache and Run Workflow much more often which would save me a lot of time. 

Currently,  using AMP Engine will cause any workflow that depends on Proxies to fail. This includes any API workflow or any workflow with Download tool, etc.

They will all fail with DNS Lookup failures.

Many newer features in Alteryx Designer are now dependent on using AMP Engine, making those features (such as Control Containers) totally useless when running inside a corporate network that uses proxies to the outside world.

Please re-examine the difference between how a regular non-AMP workflow processes such traffic vs how AMP does it, because AMP is broken!