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.
2019.4+ Server now prompts users to select an Encoding Type when downloading a csv on the gallery. Unfortunately there is no way to disable the prompt of which encoding option to utilize or an ability to select a system default. Please provide these server options as this is causing confusion across departments.
.yxdb output, csv format
(many users like the preview provided by yxdb but want excel download)
During development in Designer, when the workflow is configured to output to csv it already has the encoding configured, please provide the option to at least default this at output on the gallery:
The only alternative at this time is to republish all workbooks configured to output .csv or .yxdb to be .xlsx. This is not ideal.
Note: Scheduled jobs are not affected - I tested a scheduled run and csv files were successfully written out to a file share on the server. Content format appears to not be impacted.
... View more
I would love to be able to see the actual curl statement that is executed as part of the download tool. Maybe something like a debug switch can be added which would produce 1 extra output field which is the curl statement itself? This would greatly enhance the ability to debug when things aren't working as expected from the download tool.
... View more
The Alteryx.Flexnetoperations.com license management site needs major work. On the View Licenses page it shows all licenses going back several years. A basic need is to show only licenses which haven't expired, but that is not an option.You cannot even sort on the expiration column while you can sort on most others columns. The most simple need is to see a list of my current active license users - but I do't see a way to do that. I tried an "Advanced Search" and chose expiration date after 2019-10-29 and none of my licenses which expire in 2020 appear - I get a blank list. Similarly on the administer machines page you cannot filter to hide expired licenses or even on the licenses column (which doesn't sort either). The help link on the page doesn't bring you to help specific to that page but the general activation help front page. After several clicks I found this page: https://help.alteryx.com/licensing/current/Administer/AdministerMachines.htm?tocpath=Administer%7C__... But the help is incomplete (doesn't list Machine types or the difference between Active and Inactive) Also, there is no export capability - copy and pasting into Excel is a formatting headache as it brings in check-boxes. Lots of room for improvement here. Cheers, Bob P.S. I understand that work is being done on this, but an ETA would be greatly appreciated.
... View more
Cleanse Macro Given a choice between the delivered macro and the CReW macro, I’ll choose the CReW macro for both speed and functionality. Wikipedia says, “Data cleansing or data cleaning is the process of detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database and refers to identifying incomplete, incorrect, inaccurate or irrelevant parts of the data and then replacing, modifying, or deleting the dirty or coarse data.” If Alteryx were to convert the macro to a true tool, here is my feature request list: Performance: AMP compatible – Fast! Faster than the CReW macro for deleting empty fields/rows Resolve time it takes to load the tool (current macro versions are slow), html is faster. Feature Enhancement: Allow selection of fields based on data type Include incoming/outgoing SELECT functionality Allow for PREFIX functionality (like multi-field formula), but NOT default Read incoming metadata to provide color coding of fields to indicate where potential problems exist (e.g. NULL, Whitespace) – part of browse everywhere currently Allow for Nulls to convert to 0/blank or 0/blank to convert to Null When removing punctuation, provide for exceptions (e.g. Numeric set of negative, comma and period). Include HTML tag removal Support internationalization (character sets) Going the extra mile: Display or opt for output, cleanup metrics. How dirty was my data? Potentially, allow for ERROR to stop workflow if garbage is detected. Optional: Detect outliers in numeric data. I’ve got an outlier detection macro that we can review, but while you are passing all of the data for numeric values, explaining or tagging outliers would be useful. Could be a box-whisker on numeric values maybe? Make outlier actionable Identify in data (new field indicator) Remove Modify/Impute Test/Preview against metadata: (pre-run), see what the incoming/outgoing results would be on *all of the metadata before I run the workflow. camelCase: https://en.wikipedia.org/wiki/Camel_case Identify/Replace unknown values (e.g. N/A, Not Applicable, #) with Null() or other? Identify/Remove duplicate values within a cell See also: https://en.wikipedia.org/wiki/Data_cleansing Option to point to a “personal” dictionary for spelling or validation Provide “smart” annotation on tool
... View more