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.
This wasn't pretty (actually, it was challenging and pretty when I was done with it)!
My client receives files that include a static and dated name portion (e.g. Data for 2018 July.xlsx) within the file there are multiple sheets. One sheet contains a keyword (e.g. Reported Data) but the sheet name also includes a variable component (e.g. July Reported Data). I needed to first read a directory to find the most recent file, then when I wanted to supply the dynamic input with the sheet name I wasn't able to use a pattern.
The solution was to use a dynamic input tool just to read sheet names and append the filtered name to the original Full Path.
[FullPath] + "|||<List of Sheet Names>"
This could then feed a dynamic input.
Given the desire to automate the read of newly received "excel" data and the fluidity of the naming of both files and sheets, more flexibility in the dynamic input is requested.
There are quite a number of XML configurations available in Alteryx Designer as well as in Alteryx server. And there are possibly in different locations and each of them them is specifically for different configuration options.
Currently, there it isn't a official list of all these configuration files as well as all the configurable options. It would be good to have a centralized area to configure and visualize all these. This not only helps easier to know how to customize the tool but also help easier to maintain the backup/restore of the configuration files.
Moreover, there are possibly some settings go into the registry. This would be also good to have this centralized as well.
Ideally, a user interface would be good for these configuration with general/advanced tabs to classify the possible configuration. For server, ideally, it could be comes up the controller to distribute all these settings. For Designer, once it is configured to the Gallery, it should be able to grab the configuration and apply in the machine.
It would be very helpful to have a SOQL Edit textbox for the entire SOQL statement not just the WHERE clause. This would allow us to select fields based on parent or child relationships to the table as well.
Sometimes in a crowded workflow, connector lines bunch up and align across the title bar of a tool container. This blocks my view of the title, but also makes it hard to 'grab' the tool container and move it.
Could Alteryx divert lines around tool containers that they don't connect into, or make tool containers 'grab-able' at locations other than the title bar?
I ended up settling on the Generate Rows tool and was trying to find a way to generate rows until I had reached or exceeded the maximum density, however, I ran into an issue where I'd always have one too few rows, since the final row I was looking for was the one that broke the condition I specified.
In order to get around this, I came up with the following solution:
Essentially, I just set my condition to twice that of the true threshold I was looking for. This worked because I was always doubling the current value in my Loop Expression, and so anything which broke the 'actual' condition I was looking for ([MaxDensity]), would necessarily also break the second condition if doubled again.
However, for many other loop expressions, this sort of solution would not work.
My idea is to include a checkbox which, when selected, would also generate the final row which broke the specified condition.
By adding such a checkbox, it would allow users to continue using the Generate Rows tool as they already do, but reduce the amount of condition engineering that users are required to do in order to get that one extra row they're looking for, and reduce the number of potentially unseen errors in their workflows.
The idea is the ability to skip tools in a workflow. Check the attached example:
Input (TRX_TABLE): Contains transactional raw data (unstructured & uncleaned data) Filter (TRX_DATE <= 90 days from TODAY): It only filters the data 90 days old from today. Works as an incremental data loader If the filter tool is NOT SKIPPED the workflow loads the filtered data (incremental behavior) If the filter tool is SKIPPED the workflow loads all the data (full behavior) This way I can quickly switch between both modes for testing & production environments
Hello, I am very new to Alteryx, so my suggestion might appear elementary for the veteran-users. From the standpoint of adoptation by less technical people (moving from Excel to Alteryx), would it be possible to take common scenarios of Fuzzy Matching and automate them?
For example, if you have 2 databases and you want to match and clean them up, you have to have close to 10 steps, with sorting, adding unique identifiers, joining, fuzzy matching, etc. Just look at your video named "Fuzzy Matching" or other videos for Tableau+Alteryx. They idea is basic. If you know most common use cases and you have already developed a methodology for how to solve these cases, why not have them as part of the tools library?
Also, when matching, for example universities, wouldn't it be easier if all those common, aka appearing many times, words were automatically suggested to be removed from the "match". Example: University A and Univeristy B are two different Universities, but they share the common word "University". While it's important that this word is there, it is not the reason to pair these two together. Maually going through and identifying and typing these common words is an extra step. It would be much easier to have a pop list of these common words and the count of records in which they appear, sorted by the count, and a check box to include or exclude the words.
Link to the Fuzzy Matching video. Check Minute 9:41.
I am sure that I can't be the only person that would be interested in an output tool that allows categorical fields on both axes. THis would allow you to visualise the following example and I would suggest that this was either similar to the heatmap with boxes or the colour / size of the entry was determined by a third numerical value - such as 'Confidence' from the table below. THere might be ways to extend the idea as well as having a fourth parameter that puts text in the box or another number but it would be useful and not too hard I am sure.
I asked this before. WHY DO WE HAVE TO HAVE A POP UP WINDOW OPEN UP EVERY TIME WE RUN ALTERYX?! I asked this before, and the comment was made, "there is a check box to turn it off in the settings." Yes, that is true, there is a checkbox! And guess what, to my surprise (insert sarcasm here), IT DOESNT WORK! THE MOST BASIC, EASIEST THING YOU CANT GET RIGHT, and that is EXTREMELY ANNOYING.
Just LOST THE INTRO WINDOW. WE ALL KNOW ITS ALTERYX WHEN WE OPEN IT, DO YOU NEED THAT MUCH MORE ADULATION THAT I HAVE TO CLOSE A WINDOW THAT REMINDS ME THAT I AM USING ALTERYX?!?! Maybe I should send an email to alteryx to remind them I am using their product, will you feel even more important then? Pardon that slam here in my nastygram, but this is JUST AMATEUR!
A multi billion dollar company, and youre wasting effort with this. GEEZUZ
Is it possible to have a Sum(Column) or Total(Column) functions in formula tool? it will make the calculations much better as we don't need to use "Sum tool + Append tool + Formula tool + Select tool" or "couple of formula tools and then a select tool".
I have a problem when transferring records between different O365 Sharepoint Sites. It seems that Alteryx cannot maintain 2 separate connections at the same time. I can transfer fine if I read from one site to a temp file and then, in another workflow, read from the file and write to the second site.
I can work around the problem using Block until Done, but there are some situations where I need to be able to compare between lists in 2 different sites and write back to one or both depending on the results. it would be much more convenient to be have multiple connections open simultaneously. I'm aware that Alteryx uses the SharePoint API to move information around. This API does allow multiple connections. I'm not familiar with the internals of how Alteryx accesses the API, perhaps the OAuth token is shared through out the workflow process, but this should be posssible
In communicating with your agent Eddie Wong about a question (ref:_00DE0JJZ4._50044uMC7T:ref), he confirmed that Alteryx currently does not have an option to coalesce IDs when merging tables in the "Join" or "Join Multiple" tools. This functionality is available in SQL and SAS, for example.
This code demonstrates it.
input ID age;
input ID height;
select coalesce(d1.id, d2.id) as id,
on d1.id = d2.id;
Could you please consider adding this option into the "Join" and "Join Multiple" tools?
This suggestion is particularly relevant for macros and custom tools created with the Python SDK, but I think it can apply to other tools as well.
When searching for tools in Alteryx, I can easily find tools I want fairly quickly. However, I often don't know which tool category it is in, which can sometimes slow me down (it is sometimes faster/easier for me to go to the tool category, rather than search for the tool I want).
When in the flow of designing a workflow, I often accidentally click on the help ? Icon on the side bar of the configuration window, thereby launching a browser window, taking me out if Alteryx and interrupting my flow. Would love to have some UX indication, perhaps a different color, that clicking on this icon will redirect the user out of Alteryx.