Alteryx Designer Desktop Ideas

I think the scheduler should include another frequency otpion of every other week.  Let's say I want a workflow to run every other Monday, there is currently no simple way to do this.  There are some workarounds but they are not ideal and include some additional manual work which defeats the purpose of having the scheduler. 

Hello all,

It will be great if there is an option to specify sql statement or delete based on condition in write In-DB tool. We have to delete all record even though when we are trying to delete and append only a subset of records. If it allows for "WHERE" statement atleast, it will be very much useful. I have a long post going on about this requirement in http://community.alteryx.com/t5/Data-Preparation-Blending/Is-there-a-way-to-do-a-delete-statement-in... .

Regards,

Jeeva.

I recently began working with chained analytic applications.  One of the things that I wanted to do was to take the values selected by the end user at each stage of the app and pass them further down in the application.  I was able to do this by dumping the selected values to Alteryx databases and then using drop downs to pull the data into subsequent apps.  However, I was wondering if there would be a better way of accomplishing this.  One reason is that, with my approach, I wind up with several additional drop downs in my interface--which I really don't want.  If there's a way around this, I'd love to hear it.  Alternately, if Alteryx could potentially support doing something like this in the future, I think it would be really helpful.

The "idea" here is, for any tool utilized in a macro project, to allow any configuration setting for that tool, if desired, to be exposed to the outside world, so that when the macro is utilized in a parent workflow, the embedded tool's configuration setting is directly available to the parent workflow.

A benefit here would be the ability for users to more easily build custom tools based on the existing tools: e.g. send all inputs and outputs through a validation phase of arbitrary complexity, while leaving the "integration layer" of the encapsulated tool untouched.

When building workflows, it would be nice to have "Save Workflow" and "Run Workflow" added to the right click menu when in the canvas.

Add to Right Click menu:

Save Workflow

Run Workflow

I would love the R tool editor to work like a standard text field....it might be better explained in this scenario.  Pretend the character text is a script youve written with the function being at the top.  Let's say you'd like to move the function closer to the script, look at the weird output.  This editor pastes text like we are pasting images.

The use case is that I like to break my code into mini functions that I work on in the r console with sample data.  Once it works, I post it into alteryx and experiment with it on a small sample, then a larger sample.  If I have to have a document for my overall r cost in notepad ++, my function, and the console, it’s a little nusance, especially since I usually have to go back and forth with multiple functions.  I am not askin for a full blown editor, I like my notepad ++ for that, just a text input that works conventionally. 

SampleFunction <- function(x)
{
print(x)
}

abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz

when you paste the function (or any other text in the middle, look at this funky output)

abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
SampleFunction <- function(x)abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
{abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
print(x)abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
}abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz

The option to "Allow Shared Write Access" is only available under CSV and HDFS CSV in the Data Input tool. It would be very helpful to have this feature also included for Excel files.

Improve HIVE connector and make writable data available

Regards,

Cristian.

Hive

I would like to suggest to contemplate the option to add a new SDK based on lua language.

Why Lua?

o is open source / MIT license

o is portable

o is fast

o is powerful and simple

o Lua has been used to extend programs written in C, C++, Java, C#, Smalltalk, Fortran, Ada, Erlang

Sometimes we have workflows that fail and it is a pain to reschedule them.  I wish there was a button on the bottom right corner of each workflows result just like Output.  

It would be really useful to have a Join function that updated an existing file (not a database, but a flat or yxdb file).

The rough SAS equivalent are the UPDATE and MODIFY Statements

http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/viewer.htm#a001329151.htm

The goal would be to have a join function that would allow you to update a master dataset's missing variables from a transaction database and, optionally, to overwrite values on the master data set with current ones, without duplicating records, based on a common key.

The use case is you have an original file, new information comes in and you want to fill in the data that was originally missing without overwriting the original data (if there is data on the transaction file for that variable). In this case only missing data is changed.

Or as a separate use case, you had original data which has now been updated and you do want to overwrite the original data. In this case any variable with new values is updated, and variables without new values is left unchanged.

Why this is needed: if you don't have a Oracle type database, it is difficult to do this task inside of Alteryx and information changes over time (customers buy new products, customers update profiles, you have a file that is missing some data, and want to merge with a file that has better data for missing values, but worse data for exisitng values (it is from a different time period (e.g. older)).  In theory you could do this with "IF isnull() Then replace" statements, but you'd have to build them for each variable and have a long data flow to capture the correct updates. Now is is much faster to do it in SAS and import the updated file back into Alteryx.

I think there should be the ability to turn on and off the “Browse Everywhere” function.  I have found that my temp drive is filling up faster than it did before this most recent addition and, while I think Browse Everywhere is fantastic for QA, I don’t necessarily need it working in every workflow I run.

The excel driver (.xlsx) converts these values to 0.  If you use the legacy excel driver (.xlsx) it brings in the #N/A values.  This issue was reported in the community and I am forwarding it to the New Idea as a problem that needs to be addressed on behalf of @JohnDoe.

Hello! Almost all statistical softwares allow for the analyst to use either a pairwise or a listwise option when applying clustering techinques. This option affects only how the inner distance matrix is built, and after that whichever algorithm you choose is peformed. However in Alteryx [K-Centroids] by default does listwise, classifying only those records where the selected variables have no nulls.

Please consider adding this option!

PS: the difference is pairwise will build the distance between 2 variables depending on those records that have no nulls on both variables, while listwise will run the distance matrix after it has checked for complete non null records in all variables of interest (not one at a time distance calculation).

Hi,

Can we have a functionality to see total number of rows without adding a browse or any other tool?

PFA (output from Alteryx 10.0)

Thanks,

Rajesh Chandak

Data Analyst - Walmart

It would be very helpful to have hidden/interactive labels that can be utilized for an Report Map that only appear when the user is hovering over a specific part of the map. For example they only want to see the sales numbers for California, but do want to change the map. It probably makes the most sense to have this available for the HTML Report Maps. This would allow the report map to not look too crowded with labels, but still have the labels available if the user is interested in a particular part of the map. Is this something that can eventually be added to the report map tool?

In case of system crash/ upgrade, transfer of Alteryx license from one system to another system or from one user to another. User should be able to surrender/ borrow/ transfer license from one machine to another. This helps for more flexible use of product.

SQL and Tableau both support a CASE function with the syntax

CASE

  WHEN Condition 1 THEN Result 1

  WHEN Condition 2 THEN Result 2 ...

  WHEN Condition N THEN Result N

ELSE Default Result

END

I'm thrilled that I can now use this with the In-DB tools, but I'd love to have this available in the regular function tools so I can stop nesting my IFs!

Our DAT file structure is as follows:

The first line of the .DAT file must be a header row identifying the field neames.

The .DAT file must use the following Concordance default delimiters:

Comma  ASCII character (020)

Quote    ASCII character (254)

Newline  ASCII character (174)

Thank you,

Pete Vara