Alteryx Designer Desktop Ideas

Very simple. Use the wheel button on the mouse to reconfigure connections between nodes. You click on the origin or end and drop into the new anchor point.

PLEASE add a count function to Formula/Multi-Row Formula/Multi-Field Formula!

 

I have searched for alternatives but am just confused about how to store the result for the total number of rows from Summarise or Count Records in a variable that can then be used within a Formula tab. It should not be that difficult to just add equivalents to R's nrow() and ncol().

When workig on a module with many tools, and one of those tools is the Allocate Input tool (Experian US), whenever you try to access or configure that other tools, there is a delayed reponse.  I'm assuming because the Allocate data set is so large.  But, it would be nice, if possible, that when accessing/configuring other tools you did not get that delay.  My workaround is to Container the Allocate tool and disable it.  

As there is a DateTimeFirstOfMonth() Formula function is there any reason why there is not or could not be a DateTimeFirstOfWeek() equivilant.

Thanks,
Joe

In the Report Map tool, I'm locked from changing the 'Background Color' menu, and the color appears to be set to R=253, G=254, B=255, which is basically white. 

 

However, when we use our TomTom basemap, we see that the background is actually blue, despite what's listed in the Background Color window.  (This goes beyond the 'Ocean' layer, and appears to cover all space 'under' the continents and ocean.)  Since we oftren print large maps of the east coast, this tends to use a lot of blue ink.  I've attached a sample image to illustrate this.

 

My solve to-date has been to edit the underlying TeleAtlas text file and change the default background (117 157 181) to white (255 255 255).  Unfortunately, we lose these changes with each data update.

 

Could Alteryx unlock the Background Color menu, and have it affect the 'base' layer, underneath oceans and continents in TomTom maps?  Not sure how it might affect aerial imagery.

Hi All,

when we create formulae or filters in Alteryx, it would be great not just to
have the option to include fields (by their names) in the formulae but
also have the option to include specific values from the fields right from a drop-down menu.
 
E.g. if I have a field called ‘Region’ with 5 values like (Africa and Middle East;
Europe; etc.), filtering the database for these individual values of ‘Region’
would be simpler if I could just select the values themselves from a drop-down
list. I have now the ‘variables’ small tab in the formula configuration window but
every time I have to type the value after selecting ‘Region’== from the variables.
This is annoying with long field values - you have to be careful with pronunciation.

If a simple right click or a new tab in the configuration window would list me the values
of the field (e.g. only if a categorical variable - it can list the top 10 most frequent values),
it is simpler to write the formula.

Thank you,

Laszlo

Hi All,

Not sure if there is already tool like this, if not, it would help to have a test data generator.

It would be a combination of data type and nature of data. For e.g. Person Name whose meaning is self explanatory and is a string. Similarly phone number which is numeric but would be different than sales amount.
This can help save time during the development and QA phases when real live data might not be available and team would need to mock up such data for testing the code developed.

It may be driven by either some sort public databases like Government provides portals/APIs or internal alteryx maintained dictionary data.

An advanced step to this might be data generated by purpose. Say even inside Person name data would be different when testing a plain use caae vs master data management use case.

it would be good if this was supported among the conenctors, I can connect via third party ODBC (paid) driver but it's not really as user friendly as I'd like, I'm sure you guys would do a much better job of building a connector (hoping flattery will push help push this idea up a little 😄 )

Chris

 

 

Random forest doesn't go well with missing values and create gibberish error results for Alteryx users.

 

Here are two quick options better to add the new version;

1) na.omit, which omits the cases form your data when tere a re missing values... you loose some observations though...

 

na.action=na.omit

 

2) na.roughfixreplaces missing values with mean for continuous and mode for categorical variables

 

na.action=na.roughfix

Best

 

I would like the parse tools (regex, split to columns...) to by defualt, not point at any column.

The parse tools need to be pointed at a column, however they by defualt configure them selves to point at the first column. Every time I use them, I enter the other configuration options, such as a regular expression, then hit run. After hitting run, my output column will be populated with only null values yet I will recieve no error. 

The reason for this, is 100% EBKAC (error between keyboard and chair), as I have forgotton to point the tool to the correct column, and instead its looking at the defualt (first column)

If the defualt option didnt exist, or was blank, the tool would then error telling me to think about what im doing and point the tool to the correct column. 

I believe this change in the tools defualt behaviour would save hours of debug time, wondering why my regex statment isnt working, when in actual fact im just looking at the wrong column. 

Hello,

The Data source window allow severla kind of connections like quick connect, ODBC, etc. But the order is not the same and this is confusing :

Best regards,

Simon

Here's a great idea and one that would save me ALOT of pain.

 

Can Alteryx validate that all of the inputs are valid before it begins to run a workflow?

 

For example, I am running a workflow that takes 4-5 mins to run each time, but it will only tell me that a file is missing or a connection is invalid when it needs to read that particular file/input (this could be one of the last tools to be read). What would be amazing is to have all the inputs checked first and then run the workflow.

 

Love you guys

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Currently the select tool can reorder data by sorting or selecting the field and then clicking the up or down button.  This is tedious when you have a data set with 400 fields.  I suggest you add a drag and drop functionality to the field list to facilitate reordering data.

For the Output Tool it would be very beneficial to be able to pass a password in order to populate a password protected Excel spreadsheet. It appears there is a decent amount of interest based on the Community feedback pertaining to the subject.

Please have Alteryx check the status of any output files for read-only or locked status.  This change would prevent processing a file for an hour then having the process fail because the file was open or had improper permission. 

Idealy, the output tool should ask the user what to do rather than fail and lose all the work.

I would like the ablity to view the processing order of tools within module prior to processing and if needed reprioratize which tool processes first/last.  It would also be great to have the ablity to disable a subset of tools within a module prior to processing.

Create a new module that outputs statistics after processing. For instance creating a table of all used modules by reference number with fields for records input, records output, processing time, processor load, memory used.  As well as starttime, endtime, username, hostname, etc.  This would make debugging quite a bit easier, expecially if the results could be output to Excel.

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

From a user standpoint there’s not a good reason for these locations to not be linked.