Alteryx Designer Desktop Ideas

The "Open Example" feature that has been implemented for many tools helps new users quickly learn how to exploit Alteryx.  I would like to see Alteryx make further investments in this area and in particular I would like to see enhanced and organized documentation for functions with more and better examples.  I would encourage Alteryx to engage its ACE community and the other advanced users who are active in the Community to contribute to this effort. 

Issue: When I use any of the Multi-Field Formula tool, I lose the variable names in the field description. This is a problem when I'm working with demographic data because the name of the variable is often something like PCT0010005. The user friendly name is in the field description metadata.

Solution: Please have the Multi-Field Formula tool behave as the Formula tool does by persisting the field Description values.

Thanks!

John Hollingsworth

When creating an Annalytic App, in the Actions tab, when creating an action, have the window display the actions in numerical order.  

Often when we need to use the Filter tool and select the Custom filter option, it requires us to write conditions such as "IF", "OR" and so on.

 

Was hoping if some suggestions or hints could be embedded in the custom filter for those of us who have no experience even in basic coding.

 

 

Under options/restore defaults, it would be nice if the canvass could be reset (I sometimes lose windows), but the favorites be left intact.

Thanks!
Susan

 

I have a very large geospatial point dataset (~950GB) .  When I do a spatial match on this dataset to a small polygon, the entire large geospatial point dataset has to be read into the tool so that the geospatial query can be performed.  I suspect that the geospatial query could be significantly speed up of the geospatial data could be indexed (referenced) to a grid (or multiple grids) so that the geoquery could identify the general area of overlap, then extract the data for just that area before performing the precise geoquery.  I believe Oracle used (uses) this method of storing and referencing geospatial data.

Hello,

A lot of tools that use R Macro (and not only preductive) are clearly outdated in several terms :
1/the R package
2/the presentation of the macro
3/the tools used

E.g. : the MB_Inspect

Ugly but wait there is more :

Also ; the UI doesn't help that much with field types.

Best regards,

Simon

I would love to see an option to run only one container without having to disable all others (and tools not in containers).

 

I've got workflows with MANY different queries/tools each in their own containers and some tools outside of containers.  Occasionally I need to run or re-run just one of the containers (usually several times when the datastream contains Crosstab or Transpose tools where some fields/options will not populate until the workflow has previously run).  Normally I'd either have to disable all other containers and/or select EVERYTHING that I do not wish to run an add them all to another container that I could then disable.  An option to disable everything outside of a specific container would be most welcome and save a lot of time!

The current approach gives me both Record Counts and Total Record Size in KB, but I don't need or want the KB.

 

The option I am requesting does not currently exist.  It would remove the KB and leave you with just the Record Counts.  KB is useless to me.  I only care about Record Counts.  This option would help reduce the noise/clutter of the KBs.

Hello,

Unless you're lucky, your input dataset can have fields with the wrong types. That can lead to several issues such as :
-performance (a string is waaaaaaaay slower than let's say a boolean)
-compliance with master data management
-functional understanding (e.g : if i have a field called "modified" typed as string, I don't know if it contains the modification date, an information about the modification, etc... while if it's is typed as date, I already know it's a date)
-ability to do some type-specific operations (you can't multiply a string or extract a week from a string)

right now, the existing tools have been focused on strings but I think we can do better.

Here a proposition :

entry : a dataframe
configuration :
-selection of fields
or
-selection of field types
-ability to do it on a sample (optional)

Algo :

Alteryx	Byte	bool	only 2 values. 0 and 1	to be done
Alteryx	Int16	bool	only 2 values. 0 and 1	to be done
Alteryx	Int16	Byte	min=>0, max <=255	to be done
Alteryx	Int32	bool	only 2 values. 0 and 1	to be done
Alteryx	Int32	Byte	min>=0, max <=255	to be done
Alteryx	Int32	Int16	min>=-32,768, max <=32,767	to be done
Alteryx	Int64	bool	only 2 values. 0 and 1	to be done
Alteryx	Int64	Byte	min>=0, max <=255	to be done
Alteryx	Int64	Int16	min>=-32,768, max <=32,767	to be done
Alteryx	Int64	Int32	min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Fixed Decimal	bool	only 2 values. 0 and 1	to be done
Alteryx	Fixed Decimal	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	Fixed Decimal	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	Fixed Decimal	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Fixed Decimal	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	Float	bool	only 2 values. 0 and 1 or 0,-1	to be done
Alteryx	Float	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	Float	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	Float	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Float	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	Float	Fixed Decimal	to be done	to be done
Alteryx	Double	bool	only 2 values. 0 and 1 or 0,-1	to be done
Alteryx	Double	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	Double	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	Double	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	Double	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	Double	Fixed Decimal	to be done	to be done
Alteryx	Double	Float	when no need for doube precision	to be done
Alteryx	DateTime	Date	no hours, minutes, seconds	to be done
Alteryx	String	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	String	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	String	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	String	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	String	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	String	Fixed Decimal	to be done	to be done
Alteryx	String	Float	when no need for doube precision	to be done
Alteryx	String	Double	when need for double precision	to be done
Alteryx	String	Date	test on several date formats	to be done
Alteryx	String	Time	test on several time formats	to be done
Alteryx	String	DateTime	test on several datetime formats	to be done
Alteryx	WString	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	WString	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	WString	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	WString	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	WString	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	WString	Fixed Decimal	to be done	to be done
Alteryx	WString	Float	when no need for doube precision	to be done
Alteryx	WString	Double	when need for double precision	to be done
Alteryx	WString	String	Latin-1 character only	to be done
Alteryx	WString	Date	test on several date formats	to be done
Alteryx	WString	Time	test on several time formats	to be done
Alteryx	WString	DateTime	test on several datetime formats	to be done
Alteryx	V_String	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	V_String	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	V_String	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	V_String	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	V_String	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	V_String	Fixed Decimal	to be done	to be done
Alteryx	V_String	Float	when no need for doube precision	to be done
Alteryx	V_String	Double	when need for double precision	to be done
Alteryx	V_String	String	Same length	to be done
Alteryx	V_String	Date	test on several date formats	to be done
Alteryx	V_String	Time	test on several time formats	to be done
Alteryx	V_String	DateTime	test on several datetime formats	to be done
Alteryx	V_WString	bool	only 2 values. 0 and 1 or 0,-1 or True/False or TRUE/FALSE or equivalent in some languages such as VRAI/FAUX, Vrai/Faux	to be done
Alteryx	V_WString	Byte	No decimal part, min>=0, max <=255	to be done
Alteryx	V_WString	Int16	No decimal part, min>=-32,768, max <=32,767	to be done
Alteryx	V_WString	Int32	No decimal part, min>=-–2,147,483,648, max <=2,147,483,647	to be done
Alteryx	V_WString	Int36	No decimal part, min>=-––9,223,372,036,854,775,808, max <=9,223,372,036,854,775,807	to be done
Alteryx	V_WString	Fixed Decimal	to be done	to be done
Alteryx	V_WString	Float	when no need for doube precision	to be done
Alteryx	V_WString	Double	when need for double precision	to be done
Alteryx	V_WString	String	Same length,latin- character only	to be done
Alteryx	V_WString	WString	Same length	to be done
Alteryx	V_WString	V_String	latin- character only	to be done
Alteryx	V_WString	Date	test on several date formats	to be done
Alteryx	V_WString	Time	test on several time formats	to be done
Alteryx	V_WString	DateTime	test on several datetime formats	to be done

 

The output would be something like that

Field	Input type	Proposition	Conversion
toto	float	int	formula (with example)/native tool/datetime conversion tool…

Best regards,

Simon

I see the mention of VR but has anyone talked about touch screen capabilities with Alteryx?  Would make even the tough projects more fun!

I would like the ability to adjust the sort order of the tools displayed in the actions tab when creating a Macro, or at least have it conform to some sort order that can be easily identified. I can't currently make sense of this sort order which makes it hard to find the tool I’m looking for.

Whenever I output the Count using the Summarize Tool I am unable to tell it to sort the results by Count and am forced to grab a sort tool.  It would be nice to offer a sort option from within the Summarize tool itself instead of requiring a subsequent sort tool or to use the Results window to manually sort it.

Apologies if this has been suggested or exists. I often find myself using manual Excel files as a data source. These files frequently use cell formatting elements, such as cell color and text color, to convey important information. However, when these files are imported into Alteryx, this valuable formatting information is unfortunately lost.

 

To address this, a dedicated input tool that can read Excel files with separate fields for these formatting elements would be very helpful. This would be incredibly beneficial, especially when the data lacks other fields that relate to the coloring. Currently, I manage to achieve this using a Python tool, but integrating this as a built-in feature in Alteryx would undoubtedly be more efficient and user-friendly. This enhancement would not only simplify data preparation but also ensure the preservation of the full context of the original Excel file.

 

Multi-Fill Tool

Please consider a new Multi-Fill tool, not for Apps, but for regular workflows, manually run or scheduled.

Similar to the Interface tool-combination of the Text Box & Action (Update value) tools, this Multi-Fill tool would enable the user to update, for example, the User Name and Password in one place for multiple Download tools. It could also be used to update other tool variables like Filter, Sort, Unique, etc.

Just like there is search bar for Select Tool, there should be one for Data Cleansing tool also.

Hello All,

 

I believe there needs to be a new tool added to Alteryx. I am frequently encountering cases where I will have 0 data point feeding a workflow stream that causes my workflows to fail. Because of this, I am having to put in fail safes to keep this from happening.

 

There should be a tool that if there is no records that are passing into it, anything after that tool will not fail.

 

For an example, within a workflow I am using a dynamic input that will pull a dynamic file. The file is not always there and the workflow should be able to run if that file is there or not. If the dynamic tool and other tools would process 0 records without failing this would also solve the issue. 

 

I would be nice to have a tool that will  block off the work stream if there are 0 records passing through the tool. 

When you have a complex workflow and you need to identify what happens to a specific field throughout a LONG workflow, it would be great to have the paths, connections, etc highlighted.  

 

If the field is modified in a tool (formula for instance), the tool gets highlighted in orange.  If it just passes through a tool, it is highlighted in green and a tool where it gets dropped is colored red.

 

This will help in identifying which tools modify a field of interest as well as identify tools which "deselect" a field and cause it drop out.   I spend a lot of time tweaking workflows developed by other analysts, so this will greatly speed up troubleshooting and assessment time.