Alteryx Designer Desktop Ideas

Hi,

I think that the sample tool should have a T or F port.

Lets say I want to keep first N records but would like to stream the rest of the data (the not sampled one) somewhere else in my workflow, its possible but it would be easier to have that in the sampler. 

Simon

Korem

During the Inspire APAC conference, I dragged and dropped a tool over another tool with the intention for it to replace the tool that was on the canvas. I didnt realise that it had not replaced the tool. I kept getting errors and did not know why. The error was because the original tool was still hiding behind my new tool.

Can we add functionality where we can replace a tool on the canvas with another tool by either:

1. dragging a tool from the tool palette over another tool and it replaces that tool with the tool from the palette (the tool being replaced will turn grey whilst you hover to indicate that you are about to replace the tool. 

2. Right-click an existing tool and similar to insert after context menu, a replace tool context menu appears to select the tool that will replace the existing tool.

Also, if you can include in user options, an enable/disable checkbox for this function as I am not sure whether everybody may want this but this is a productivity hack when you change your mind later in the type of tool you want connected. Drag and Replace is very intuitive action which is used in other design software platforms. The only reason I can think of where you would drag and drop a tool directly over another tool is to replace it. Say you have the join tool on the canvas and you really want a union. Or you want to replace the predictive model being run without having to delete and then drag and drop the right tool. These are 2 examples among others where you reduce the number of actions taken to replace the tool currently on the canvas.

Happy to elaborate with more examples if the above does not make sense.

For the split to rows function on text to columns, can we have an option in the configuration to warn/error on too many records being generated just like the append fields tool but replace the words appends with splits?

I found a great use for the visual Layout Tool which solved the formatting issues I was running into. Unfortunately it doesn't pass through additional columns from the source. This means that I am unable to use the batch rendering (the "group data into separate reports" functionality in the render tool). See images below.

Image 1: Layout keeps columns in output 🙂

Image 2: Visual Layout drops columns in output

 Cheers

With the version 2019.4 an option to open all autosaved workflows has been created. I liked it. It would be really helpful if I can open multiple workflows from gallery.

thanks

I realize a true "In-DB" version of the SharePoint tool may not be possible due to the complexity and layers to get to an actual SharePoint Database. However, would it be possible to add some parameters for pre-filtering? O365 version of SharePoint has some timeout limitations that cause the SharePoint tool to fail randomly. If I could specify parameters (such as a date minus some number of days or hours on a particular date field) to filter the dataset. Or specify record ID ranges to pull records in batches, this would allow users to work around this issue.

As a Left-hander I use my Mouse in my Left hand and use my Right hand for keyboard short cuts.

In many windows products that means I can use the CTRL-INSERT, SHIFT+INSERT, SHIFT+DEL for copy, paste, and cut.

In Meta-info windows in Alteryx I can do this, but in the workflow windows I can not.  I'd like the functionality added.

Creation of a Multi Append Fields tool instead of having to use Multiple Append Fields to join man different columns.

my company utilizes a lot of power pivot, but I am not seeing this as an available data source. Could this be implemented so that we could seamlessly incorporate our existing power pivot tools into ALteryx workflows?

Please let me know if I've overlooked a suggestion and I'll be glad to upvote that post.  

Just as we're able to right click a input and turn it into a macro imput for example, it would be helpful to turn formula into In-Db formula and the same goes for all the other tools that are available both inside and outside In-Db.

I created several fields inside a formula tool and later on, I had to do the same but In-Db, the field names and rules were the same, if I could I would just turn the one I already had into an In-Db tool.

Thanks.

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 am trying to run batch regressions on a pretty sizable set of data.  About ~1M distinct groups of data, each wtih 30-500 x,y pairs.

A batch macro with a linear regression works ok - but it is really slow.  Started at about 2-3s per regression.  After stripping out bunch or reporting from the macro, I am down to ~2s.  This is still feels quite slow compared to something purpose built.

Has anyone experimented with higher speed versions that just dump out m,b, & r2?

Passing Access and Secret Keys to connect to AWS S3 poses a security risk. It would be great if the Amazon Redshift Bulk Connection tool was enhanced to include an authentication option to use a Native IM group instead of keys.

I want to use contains to search multiple strings and "IN" for multiple targets within the same formula. 

IF Contains(([MJE Text]+[Ref Fld 1]+[Ref Fld 2]+[Ref Fld 3) IN("Accrual","Acc","CCRUAL")) THEN "Accrual" ELSE "" ENDIF

Can this be developed?

It would be nice if we could right click on a Tool from the canvas and add it to Favorites from there.

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 /

https://community.alteryx.com/t5/Data-Sources/SharePoint-List-Input-Problems-importing-content-types...

Hi - I miss the functionality in 9.5 of being able to set a default tool in a tab and then drag in tools from the tab. This seems to be gone in 10. Is there any possibility of it coming back?

Many thanks - Nathalie

It will be great if we have a round down or round up function just like excel in Alteryx. I know we can use the left function after converting the number to string, but it becomes difficult when the decimal value is huge.

For Snowflake Bulk loading only AWS S3 is supported.  ODBC works but has slower performance.  Adding the Google Cloud Storage option would allow more customers to use this feature.