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.
Seeing how we use browse to tools to help build out modules, but they slow down the modules because they write out temp files, it would be awesome to have a "record count" option similar to the input tool. This would allow us to see the data as it's flowing through the module without slowing it down. Adding a sample tool before every browse would be fairly cumbersome.
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 you copy and paste a layout tool to keep the formatting you just spent hours fixing it goes away as soon as you paste it. This is infuriating. Please keep the formatting from resting upon pasting.
Attached are pictures of a copy and pasted layout tool connected to the same incoming data source.
You can clearly see that the order and formatting has been removed. #Infuriating
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.
It would be nice to have a function similar to IsEmpty() that would also return true if the string only contained spaces. Of course the simple work around is to Trim() inside IsEmpty(). Just trying to save a few keystrokes and remove a failure mode if you forgot to Trim()...
When it comes to something going wrong in Alteryx the last thing I can ever remember is the email address to use for support. Instead of trying to remember whether to use customersuccess@ or clientsvcs@ why can't it just simply be support@?
At your time of need, please make it as simple as possible to get help.
It would be nice to have the ability to double click the top area of a container to either show or hide the container's objects. Only being able to show or hide containers using the arrow icon in the top right is quite cumbersome for large containers because it requires a lot of horizontal scrolling in order to change the desired view of the modules workflow.
When pushing rows out to a SQL server table that has an identity column - we often need to use an Output clause in the insert statement to return the new primary keys used so that these can be passed on to the next step.
In cases like this - the output tool should be able to pass these IDs on to the next tool for down-stream manipulation (i.e. the output tool needs to be non-terminal node - so that it can have an outbound connector to pass this on).
This is a very common problem when inserting into a dimension table with an integer primary key, which you then need in order to pass this onto your Fact table loader.
Create table Pets ( PetID int identity(1,1) primary key not null, PetName varchar(20) not null,
Age int not null, )
Truncate table Pets GO Insert into Pets output inserted.petID, inserted.Petname values('Fido',10)
Insert into Pets output inserted.petID, inserted.Petname values('tweety',15)
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!
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.
With more people moving into urban developments, it would be helpful to allow analysts to measure customers within a "walking distance". Similar to drive time analysis, a step up would be to incorporate "walk time" analysis.
It would be nice to have the ability to have a workflow wait/pause tool that would pause the workflow for a given amount of time before proceeding to the next step (i.e. wait 300 seconds).
I have a workflow that uses the Run Command to run a batch file that kicks of a terminal emulator that cycles through steps the ultimately result in an exported text file that I use in an Alteryx workflow for further processing. The generation of the text file can take a few minutes. A delay could be placed in the batch file or terminal emulator script, but I think having a tool in the Alteryx workflow might be useful for other processes as well.
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.