Alteryx Designer Desktop Ideas

If I need to change field text using an If Statement, I have to write in in a format similar to this:

 

IF [Product Line]=="" THEN
    "Others"
ELSE
    [Product Line]
ENDIF

 

Having an Else statement increases processing time and statement complexity and in this case is unnecessary.  Please allow me to write my code in this manner:

 

IF [Product Line]=="" THEN
    "Others"
ENDIF 

I would like to see the Publish to Tableau Server tool updated to allow appending an extract with Encryption at Rest enabled.  As data security requirements become more stringent, this would be a beneficial option.  Right now, I'm only able to create or overwrite an extract if I've turned on server-wide encryption at rest enforcement in Tableau Server.

Hi, I'm new to Alteryx; we've had for just about a month. We started publishing our workflows to Tableau and it's working great.

One issue I foresee:

User credentials to the Tableau server are updated occasionally. When this occurs, I will have to update the credentials manually in each workflow. 

The number of workflows we are publishing is growing. Is there a way to automate this process? 

*This is an idea from @sayuri  from the Portuguese Community*

 

• Create a button to add any tool to all output anchors of selected tools (similar to “Add All Browses”)

Allow users to disable any steps in workflow except input and Join conditions.

 

To edit existing workflow sometime we may required to remove few steps, it is better if we have option to disable and update mapping instead of delete.

Pulling data down from Salesforce takes a looong time. It would be a great feature to be able to cache this, similar to how 9.5 added database caching.

Figuring out who is using custom macros and/or governing the macroverse is not an easy task currently.  

 

I have started shipping Alteryx logs to Splunk to see what could be learned.  One thing that I would love to be able to do is understand which workflows are using a particular macro, or any custom macros for that matter.  As it stands right now, I do not believe there is a simple way to do this by parsing the log entries.  If, instead of just saying 'Tool Id 420', it said 'Tool Id 420 [Macro Name]' that would be very helpful.  And it would be even *better* if the logging could flag out of the box macros vs custom macros.  You could have a system level setting to include/exclude macro names.  

 

Thanks for listening.

 

brian 

It should be made more clear when a container is just closed versus inactive/deactivated. Maybe highlight the container header in pink or light red if it's just closed and not deactivated. I've seen others in my group make the mistake of assuming the container is inactive if they simply close it. The current switch is kind of subtle. 

Have a feature in Alteryx that automatically and dynamically creates documentation or a SOP standard operating procedure. I imagine the flow and connectivity of each process  would cause it to be easy enough to translate from a visual display into a written form. This would be extremely helpful to workflows that touch and handle data that has to be accounted for, whether that be through an audit or any other forms of IT controls.

Hi

 

While the download tool, does a great job, there are instances where it fails to connect to a server. In these cases, there is no download header info that we can use to determine if the connection has failed or not. 

 

Currently the tool ouputs a failure message to the results window when such a failure occurs. 

 

Having the 'failed to connect to server' message coming into the workflow in real time would allow for iterative macro to re-try. 

 

Thanks

 

Gavin

 

it would be helpful to have the ability to search within field names in the Configuration panel 

There are times where I can have very long lists of field names, and although sorting is helpful, a "Search in .. " feature would be even more so

 

I did not see this specifically requested in the forums

 

thanks

aoxomoxoa

 

 

 

I made a search on LDA - Linear Discriminant Analysis on Alteryx Help and it returned "0" Results.

 

 

Idea: LDA - Linear Discriminant Analysis tool

to be added on the predictive tool box.

 

 

 

Rationale: We have PCA and MDS as tools which help a lot on "unsupervised" dimentionality reduction in predictive modelling.

Bu if we need a method that takes target values into considerations we need a "supervised" tool instead...

 

 

 

"LDA is also closely related to principal component analysis (PCA) and factor analysis in that they both look for linear combinations of variables which best explain the data.[4] LDA explicitly attempts to model the difference between the classes of data. PCA on the other hand does not take into account any difference in class, and factor analysis builds the feature combinations based on differences rather than similarities. Discriminant analysis is also different from factor analysis in that it is not an interdependence technique: a distinction between independent variables and dependent variables (also called criterion variables) must be made."

I know there is an idea for Dynamic Summarize, however I think with only small change to Summarize tool this could be achieved. 

 

If we set the Summarize to Group by all our dimensions but then use ListBox + Action to control which dimensions we want to select - wouldn't it be nice (ahh Beach Boys comes to mind) to be able to tell Summarize tool that if the dimension in group by is not found just ignore it? At the moment it throws an error. I just think such small configuration would achieve this, right? 

 

Please let me know what you think

I am aware there are posts on this in the community and that there is a macro available to do this on the public gallery, however I think this is such important functionality that it should be incorporated into the main product.  I want to be able to join 2 data sources by a date range.  In SQL the code would look like this:

 

select ric.*,map.*
from
Staging.TicksHourlySummary ric
LEFT OUTER JOIN Reference.ReutersInstrumentCodeMap map
on (
ric.#RIC = map.ReutersInstrumentCode
and ric.[Datetime] >= map.EffectiveFromDate
and ric.[Datetime] < map.EffectiveToDate

)

 

 

Add a search or find function that looks for content within a tool rather than just the tool number. e.g. ctrl Find, to look for any tool that uses a keyword or field in the formula/join/etc. This would save me a boatload of time editing, updating, and troubleshooting my workflows.

After we change to a new type, the Forced option should be appear in the new type.

 

screenshot below is example, i change to V_string but the forced option is still in double.

 

it very annoying to change via 2 select tool or edit in xml

 

 

It would be very helpful to do some basic KML formatting, especially changing line/point colors.  To be able to choose colors based on values in the data to make thematic maps easier would save me time.  Maybe within the output tool for KML, or as a spatial tool?

Hello,

 

the randomforest package implementation in Alteryx works fine for smaller datasets but becomes very slow for large datasets with many features.

There is the opensource Ranger package https://arxiv.org/pdf/1508.04409.pdf that could help on this.

 

Along with XGBoost/LightGMB/Catboost it would be an extremely welcome addition to the predictive package!

Could we please have the option of selecting the fields, like the join tool, within the Calgary Join tool?  It is especially problematic when I simply want to assign spatial object name to a point; i.e customers within a DMA or sales territory.

 

This would be agreat addition within the ConsumeView Matching tool as well.

 

  Thanks!