Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesHello,
After used the new "Image Recognition Tool" a few days, I think you could improve it :
> by adding the dimensional constraints in front of each of the pre-trained models,
> by adding a true tool to divide the training data correctly (in order to have an equivalent number of images for each of the labels)
> at least, allow the tool to use black & white images (I wanted to test it on the MNIST, but the tool tells me that it necessarily needs RGB images) ?
Question : do you in the future allow the user to choose between CPU or GPU usage ?
In any case, thank you again for this new tool, it is certainly perfectible, but very simple to use, and I sincerely think that it will allow a greater number of people to understand the many use cases made possible thanks to image recognition.
Thank you again
Kévin VANCAPPEL (France ;-))
Thank you again.
Kévin VANCAPPEL
When several fields are marked the marking of check box should apply to all selected fields.
When changing Type the change should also apply to all selected fields.
There should also be shortcut keys for doing this.
This is a really common task and would save a lot of time. I'm actually really surprised it does not already exist in Alteryx Designer.
It would be extremely helpful if there is an easy way to print off the current function reference for 11.0. In the past, you could easily do so with 9.5 (with the print button), but even putting out a basic PDF file that outlines the parameters for each function, and what it does would be useful. This is not possible with the newest version of the documentation.
https://help.alteryx.com/9.5/index.htm
It would be extremely helpful if the Alteryx documentation expanded more on how to specify a basic character class from within the documentation page:
so that you could easily tell Alteryx what character class you want, as outlined here:
Currently, it is very hard to look at the documentation, and know what characters encompass what class. Adding this would be extremely useful. The only way I found the syntax was through the formula menu, which is depressing that its not on the function reference page itself:
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/RegEx-Perl-Syntax-Guide/ta-p/1288
I absolutely love that version 11.05 added the "open containing folder" function to each workflow tab. Can you add the same to input files?
I'm stealing this idea from Tableau's number formatting, it's a timesaver.
In the DateTime tool if I've initially selected a value besides Custom in the "Select the format..." list then when I click Custom rather than having the Custom textbox be blank I'd like to have it automatically populated with whatever formatting string I just selected. Here's an example screenshot:
I have used Publish to Tableau Server macro for over a years. It works fine when I want to overwrite the data.
However, the current macros (from Alteryx Gallery and Invisio) won't work with appending the data. Please modify or develop a workable macro for 'Append the data to Tableau Server'. It will save a lot of time in the daily update process.
Note: I am using Alteryx 11 and Tableau 10.1. Thank you very much.
I would like to request that IBM Big Insights become a supported data source. Currently I have been unable to connect Alteryx Designer to Big Insights through any ODBC driver.
The tokenize would be more powerful if in addition to Drop Extra with Warning / Without Warning / Error, you could opt to have extra tokens concatenated with the final column.
Example: I have a values in a column like these:
3yd-A2SELL-407471
3vd-AAABORMI-3238738
3vd-RMLSFL-RX-10326049
In all 3 cases, I want to split to 3 columns (key, mlsid, mlsnumber), though I only care about the last two. But in the third example, the mlsnumber RX-10326049 actually contains a hyphen. (Yes, the source for this data picked a very bad delimiter for a concatenated value).
I can parse this a lot of different ways - here's how I do it in SQL:
MlsId = substr(substr(listingkey, instr(listingkey, '-')+1), 1, instr(substr(listingkey, instr(listingkey, '-')+1), '-')-1)
MlsNumber = substr(substr(listingkey, instr(listingkey, '-')+1), instr(substr(listingkey, instr(listingkey, '-')+1), '-')+1);
With Regex tokenize, I can split to 4 or more columns and then with a formula test for a 4th+ column and re-concatenate. BUT it would be awesome if in the Regex tokenize I could instead:
1. split to columns
2. # of columns 3
3. extra columns = ignore, add to final column
When adding multiple integer fields together in a formula tool, if one of the integer values is Null, the output for that record will be 0. For example, if the formula is [Field_A] + [Field_B] + [Field_C], if the values for one record are 5 + Null + 8, the output will be 0. All in all, this makes sense, as a Null isn't defined as a number in any way - it's like trying to evaluate 5 + potato. However, there is no error or warning indicating that this is taking place when the workflow is run, it just passes silently.
Is there any way to have this behavior reported as a warning or conversion error when it happens? Again, the behavior itself makes sense, but it would be great to get a little heads up when it's happening.
Hello all,
Within the databases that I work in, I often find that there is duplicated data for some columns, and when using a unique tool, I have little control of what is deemed the unique record and which is deemed the duplicate.
A fantastic addition would be the ability to select which record you'd like to keep based on the type + a conditional. For example, if I had:
Field 1 | Field 2 | Field 3 |
1 | a | NULL |
2 | a | 15 |
I would want to keep the non-null field (or non-zero if I cleansed it). It'd be something like "Select record where [Field 1] is greatest and [Field 2] is not null" (which just sounds like a summarize tool + filter, but I think you can see the wider application of this)
I know that you can either change the sort order beforehand, use a summarize tool, or go Unique > Filter duplicates > Join > Select records -- but I want the ability to just have a conditional selection based on a variety of criteria as opposed to adding extra tools.
Anyways, that's just an idea! Thanks for considering its application!
Best,
Tyler
In my use of the Data Cleansing I want all the fields to be cleansed. Selecting the ALL choice selects all the fields, however if new fields are added later they are not automatically added. Perhaps the addition of a UNKNOWN choice as in the SELECT tool.
Thanks!
Hi all
It would be helpful to have the possibility to work with placeholders in zip file input:
1. placeholder for zip file itself c:/data/*2017.zip
2. placeholder for the files in the zip file *raw.csv
It would make it easier to automate daily zip files with files with the same structure in the zipped file.
Kind regards
Steffen
Hi All,
It would be great if Alteryx 10.5 supports connectivity to SAS server.
Regards,
Gaurav
The object name is too long in NFD/NFC when connected to Teradata Error occurs when you use SQL comments above the SELECT statement within the Connect In-DB customer query box. Once the comments are removed the problem is resolved. It would be great if the Connect In-DB tool could recognise comments as what they are.
I want to use Alteryx to pull data from a SharePoint List. This shouldn't be a problem, but I use SharePoint Content Types. Alteryx won't allow me to import any list that has Content Types enabled; thus rendering the SP list input type not usable.
My interim workaround is to create a data connection thru excel to the list and then pull the data in that way, but optimally, I would like to pull directly from the list.
Content types are a best practice in SharePoint, so any list or library in my site collection contains them.
Please update the SharePoint list input to support content types.
thank you,
Someone else inquired about this but I didn't see an idea entered /
My system's regional settings are German that uses a different decimal symbol and digit grouping than an English system.
Frequently I need to copy data from a browse tool in Alteryx to Excel to create a quick chart or further analysis; this often includes float or double data types.
Instead of the in my case correct ',' as decimal symbol, Alteryx uses the English '.', hence would cause incorrectly pasted values in Excel.
Always using an Excel file as output data is time consuming.
The request is: Make Floats and Double aware of the systems regional setting for copy and paste out of results.
I have a column called Recency that only has values from 1 to 5. When I view the data using the Browse tool I see a scatter graph of the data that tells me very little apart from the fact that they only have values from 1 to 5. It would be much more useful to display a histogram showing how many records have 1,2 etc so I get a better idea of the data quality.
Issue:
Currently there is no "In - Database" node to perform action queries
Work around
Use of the pre / post SQL in "Output data" node to perform action queries
Impact
Alteryx ease of use of "In - Database" nodes to work on large scale databases
Currently use of Knmie and SSIS is preferred instead of Alteryx
Action Requested
Please add an action query node to "In - Database" group.
Using Render tool to create an excel document.
(This is for a specific use case)
If you are using the RENDER tool to create one or more EXCEL documents. Ensure that you are NOT explicitly stating the Sheet name in the file name. (Output file or 'Replacing entire Path with Group).
If you explicitly name the sheet, it will throw an inboundPipe error.
Remove the sheet name, and it should work fine.
You have a slide within a slide and if your window is not big enough you don't even see both slides. Makes absolutely no sense and is super annoying.