Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Split One to Multiple (Reverse of Join Multiple)

I'd like to see a tool that can take an input, then send it in different directions (similar to formula tool), but with many options... based on filters and/or formulas and/or fields.

 

Sometimes I need to perform actions on parts of my data or perform different actions depending on whether the data matches certain criteria and then re-union it later.

 

Right now, the filter tool only allows true or false. If we could customize further we could optimize our workflows rather than stringing filter tools together as if they are nested if/then.

So either the filter tool could have more options than true/false, and infinite ouputs, or the join multiple tool could be flipped, as shown below.

 

I envision something that says:

Split workflow:

  • By Field: Field Name (perhaps with summarize functions such as min/max, etc.)
  • By Formula (same configuration as current)
  • By Filter
    • Field
    • Operator
    • Variable

FlipIt.png

 

9 Comments
andrewdatakim
12 - Quasar
12 - Quasar

Hi cbridges,

 

You can use the Dynamic Select tool with the formula and select based on a field name group or criteria. I use this on occasion and then rejoin if necessary. It will still require you to create one select tool per grouping but it does eliminate the need to update manually if your naming conventions remain consistent.

 

Regards,

Andrew

JohnJPS
15 - Aurora

Cool idea, but I think the tricky part here is that... well, for example with the MultiJoin tool, it's easy to accept any number of inputs with just one output, because downstream you won't have to decide which output you're looking at.  Even for various tools that already have two or three outputs, those outputs are well defined regardless of the use case.

 

I'm not sure how they would support an undefined number of outputs based on user configuration. How would the downstream tool know which output it's getting?  I'm sure there's a way to do it, but I'm not sure there's a way that's significantly easier than a bunch of Filter Tools, (e.g. Michael's response in the question thread).  For something significantly complex (requiring lots of separate logical branches with fairly similar processing), it may be better to look at iterative macro that processes each sub-group independently, rather than numerous Filters.

 

cbridges
11 - Bolide

I'll check it out @andrewdatakim!

@JohnJPSI probably didn't use the best example in my picture. A better example would be reversing the union tool. A data set would come into the tool and instead of having chains of T/F filters, you could say if X then output 1, elseif Y then output 2, elseif Z then output 3. From there on your workflow handles it exactly as it would a filter tool where one flow goes left and one goes right, except that the outputs would be numbered (or better yet, designated a label in the tool), just like the inputs into the union tool are now. Your outgoing connections could be 1, 2, 3 or X, Y, Z and then you do whatever you want with the data from there on.

 

For my use cases, I would typically want to union the data back to itself farther on downstream.

 

JohnJPS
15 - Aurora

@cbridges thanks for clarifying. Good idea!

robshiffer
7 - Meteor

I'd also be interested in a similar functionality for work that I'm doing

Much needed tool I reckon. Trying to do something similar and initiated a discussion.

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-Filter-based-on-the-values...

 

Got around my issue using a batch macro but again that wasn't generic as the proposed tool would be.

 

kiya
5 - Atom

can any one help me on ,loading multiple xml file to multiple database table /dynamic/?

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
danniemme
7 - Meteor

I haven't had any luck finding a clear answer for this. The big issue, as you've cited is that the filter tool does this but it's not very dynamic. So as a bandaid: I just used a sum tool to group by the column I want to break the data apart by. Then used record ID's to assign a numeric value to every field in that column. So I've effectively created dynamic numbered "buckets." Then I joined the "buckets" with record ID back to my original dataset with the specific field being the same column I summed. Now I can filter it by record ID. Unfortunately, this only really works if you have a limited # of groups. Fortunately, I can limit my input.