This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I was with my friends at Limited Brands yesterday and they pointed out to me a way to improve Alteryx. While designing a workflow, each time you add an input tool to the canvas you literally have to start from scratch to add additional tables from either a db datasource or file source (e.g. access). With other tools, you can drag multiple tables to the canvas at once and come back later and add more inputs without having to select your source, see a list of tables etcetera.
On their behalf (they may post another suggestion), I am posting this idea.
I get a lot of adhoc requests where the insturctions are in the actual email. As I'm going through the ask, creating the new workflow, the requester will mention "column C" or "column XY", but I'm viewing the data in Alteryx where that doesn't show. So I have to open the Excel file, find the column, get the name, go back to Alteryx to locate the column I need, run the module but get an error/no results because I forgot to close the Excel file (because the module is using the same file I just opened to validate which column I'm using).
It would be really cool to have an Option in the Input tool to add the Excel column lettering and numbering to show (Ex, Column A, B, C, D going left to right, Row 1, 2, 3, going top to bottom). This would just be visually showing it, not adding it to the data (because then you would lose the actual column names). If this can be done, it would be equally as useful in the Browse tool view. Have a great day!
When testing a macro with interface tools in use - the value that is used if running in normal execution (hit the big play button) is 0 or blank, irrespective of the value set for default on the component.
put an up-down component on a canvas with a default value of 200
Then hook it up to a formula box
Then output the value
The value which is output is 0
Please can you change this so that the value passed through the interface tools in testing mode is the specified & configured default value?
I find the concept of Batch and/or Iterative macros, when done specifically for the simple purpose of iteration, to be a fair bit of overhead. If we could extract the fundamental qualities of a loop and get that into an "Iteration Tool," it could become a well-used tool from the pallette.
Assume that the iteration is over the rows of a given input data set.
For the "body of the loop" allow multiple expressions, each of which iteratively assigns the i'th position of a given variable (which could be either existing or derived just like the Formula tool and it's expression).
Allow referencing of the loop index variable from within expressions
If the input data set from that example were sent into the proposed Iteration Tool... it would automatically loop over the dataset rows; and three expressions could be supplied in the Tool configuration to solve the problem:
VarE: IF [i] > 1 THEN VarF[i-1] + VarG[i-1] ELSE VarE ENDIF
VarF: VarA + VarB
VarG: VarC + VarD
For implementation purposes, this would be logically equivalent to:
VarE[i]: IF [i] > 1 THEN VarF[i-1] + VarG[i-1] ELSE VarE[i] ENDIF
VarF[i]: VarA[i] + VarB[i]
VarG[i]: VarC[i] + VarD[i]
(so, basically, the i'th row is assumed unless otherwise provided in the expression syntax).
I hope this isn't too outlandish - I've tried to think through how this could be accomplished (1) as a tool that is not too fiendishly difficult for Alteryx to implement and (2) which would also be easy for us, the end users, to utilize. Thanks!
Add an option to cancel an occurrence currently queued to run without it removing, or completing, the original schedule. Not sure if this is by design or a bug but when you cancel a workflow that's in queue, it sets the scheduled workflow to "Completed" even though you just wanted to stop that occurrence and still keep the workflow schedule “Active”.
Also, adding an option to PAUSE a scheduled module. This is useful when you need to temporarily suspend a workflow from running, but save the hassle of re-configuring the schedule when you want to turn it back on.
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.
I have a process where I output data to a database each week. Because the database fields have a pre-defined/expected data type, I must maintain that same data type in my workflow. However, I would still like Alteryx to determine the max size of the fields for string fields. The Auto Field tool does both, and sometimes it might change the data type of a field based on the records being passed at the time.
The reason is because the output to the target database is fastest when you make the string field sizes as small as possible. So, hard-coding the field sizes has inherent inefficiencies.
I have a big need to input files created in a .sqlite format and also write out to files as .sqlite that contain spatial object fields. Currently they are not recognized as spatial objects. BlobConvert is not able to convert the spatial fields from the input correctly (it gets close) so the result is that we are unable to utilize any spatial fields from or to these files.
I would like to see the same functionalitly that the Output Tool has in the Render tool. In the Output Tool, you can specify the Excel Worksheet along with the Sheet Name that you want to output too. Meaning Same Worksheet, different tab:
As a MicroStrategy customer it would be nice if Alteryx would support output for either the .mstr file format or better direct creation and publication of the iCUBE, intelligent cube format on their server solution. This would be similar to the existing features of writing a twbx or TDE file extract and publish to Tableau server.
Opposite if the Input connector could read from an intelligence cube on the MSTR iServer as datasource that would be great as well.
Below a link to their SOA webservices documentation to pull data into applications, perhaps an option.
When processing multiple files using wildcard character, Alteryx workflow fails when there is empty file. Skipping zero size file option would help. Else, I have to write a batch macro and process each file separately.
It would be great if the mapping allowed point themes to be bi-variate, i.e. you could change the size of a point at the same time as adjusting its colour to show two variables on the map at once, relative to each other.
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.