Branching on Filter tool

Question

Dear All,

I have multiple branches in the workflow after the filter tool,

After each run, data will be flowing only to one branch and later there is a common workflow for all.

means -

Alteryx workflow -> Filter-> workflow1 -> Alteryx workflow.

Please help, how can i configure this-

Alteryx workflow -> Filter -> workflow branch 1

workflow branch 2        -> Alteryx workflow

workflow branch 3

TIA

clmc9601 · Answer

Hi @Ekta,

The above idea about a batch macro could help, but if you place the same formula inside it, it will still error when missing a column. Alternately, here are three more suggestions:

- Rather than using a regular formula which is dependent on column names, use a multi-field formula to reference "current field" dynamically. Also it looks like at least the first couple cells in your formula are all doing the same thing (replacing a character) so multi-field formula would be more dynamic anyway. Just be sure you select "dynamic or unknown fields" at the bottom of the list of fields to apply to. This might be the best solution depending on the full contents of your formula tool.

- Transpose your data so that [A], [B], [C], are all in the Name column and the values which you are fixing are in the Value column. Then you will only need a single formula tool and there will always be a name column. If your key columns will be changing too, this could be tricky. But it could partially be fixed with the next solution.

- Use a dynamic rename at the beginning of your container to name the columns positionally 1, 2, 3, 4, etc. More specifically, use a text input tool to input 1, 2, 3, 4, etc through all the possible number of columns. Then set the dynamic rename tool to take names from right input rows and assign them positionally (be sure to select "dynamic or unknown fields" too if relevant). Then the column names will always be sequential. Formula will still struggle if you have different numbers of fields though. But, if your key columns are always in 1 and 2, this will help transpose.

If these suggestions are still insufficient, could you share the full configuration of your formula tool?

afv2688 · Answer

Hello @Ekta,

I have recently solved a similar issue to another user. Check out this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Enabling-Disabling-Containers-based-on-a-Condition/m-p/707276#M165427

If you need some clarification let me know 🙂

Regards

Ekta · Answer

@clmc9601  Thanks a lot for the reply,

This is my sample workflow- based on the filter tool the data will flow to any one branch- but since above branch have error due to missing column , its not going through Union.

Please help me with this.

TIA