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.
At the moment the salesforce connector does not support view objects like AccountUserTerritory2View. It should be extended to support those objects to facilitate more efficient and above all complete data extraction.
I have a 1000 row excel workbook with multiple sections on the same sheet, each with a unique header. Each section has exactly 16 rows of data included. I want to pull the rows only from one specific header called "wages".
I tried using a multi-row formula and the below expression to pull only these 16 rows but it isnt working. Any ideas?
IF Contains([F1], "Wages", 1)
THEN [Row+1:Test]+1 & THEN [Row+2:Test]+1 & THEN [Row+3:Test]+1 & (... all the way to +16)
Extend the machine-learning framework for pressure analysis on a single well to multiwell systems.
The framework should capture the well interference accurately and be able to test a greater area of the reservoir. Develop a machine-learning model to reconstruct the flow-rate history by use of pressure data. Ensure that both models maintain the advantages of the machine-learning- based single-well pressure interpretation in terms of the accuracy of prediction, computational efficiency, and tolerance to noise.
It would be helpful if Alteryx did not try to report blank dates in the data profiling tool that are not existent in the dataset. If our data is missing dates, it would be better to report these as a warning, rather than making the profiling imply that they should be within the dataset. Attached is a simple dataset to illustrate.
This is an interface issue but I wish Alteryx can allow user to scroll across the ribbon toolbar (e.g. In/Out, Prep, Join, Spatial tools...) when the toolbar is active.
That is, for example, when I click on "Transform" and notice my tool is not there, I can quickly scroll my mouse to move to other toolsets. Microsoft Office is a best practice for this and I think this will make it much efficient to locate tools.
Currently only 5 workflows are displayed per page in a collection. Currently we have about 30 workflows (soon to be about 100) and paging through workflows to find the one you want to run is time consuming.
It would be great if there was an option on the page so the user could select the number of workflows per page.
When using the Transpose tool I'm pivoting out networks names to column headings then I want to populate those fields with an "X". To do this I have to first create a column first with an "X" in it and populated the various Networks columns with that.
How about another drop-down that says something like "I'll key the value I want to populate the fields with" and I can key "X" or "Y", etc.
It's possible I just don't know enough about the tool but I can't see how to do this other than my way.
When using the Levenshtein distance matching in the fuzzy match it gives you the option to select a match threshold % but does not allow for other options. Is it possible to provide these additional options in a future release?
Similar to the regular formula tool, it would be great if we would be able to configure multiple text to column processes within one tool rather than having to line up several tools when having to convert various fields of different logic at the same time.
Designer should support statistical testing tools that ignore data distribution and support Statistical Learning methods.
Alteryx already supports resampling for predictive modeling with Cross-Validation.
Resampling tools for bootstrap and permutation tests (supporting with or without replacement) should be tools for analysts and data scientists alike that assess random variability in a statistic without needing to worry about the restrictions of the data's distribution, as is the case with many parametric tests, most commonly supported by the t-test Tool in Alteryx. With modern computing power the need for hundred-year-old statistical sampling testing is fading: the power to sample a data set thousands of times to compare results to random chance is much easier today.
The tool's results could include, like R, outputs of not only the results histogram but the associated Q-Q plot that visualizes the distribution of the data for the analyst. This would duplicate the Distribution Analysis tool somewhat, but the Q-Q plot is, to me, a major missing element in the simplest visualization of data. This tool could be very valuable in terms of feeding the A/B Test tools.
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.
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
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.