Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Disable part of workflow if no filter returns False

fardeen9983
8 - Asteroid

I have a workflow where I am trying to get only row as output. The issues I have are as follows:

 

1. The container runs the Input macro even if the Filter has no True records

2. In the browse tool for the union you can see I have two records as output. What I want is for them to merge into one record with the 2nd row overwriting the 1st one if it is not null

 

Issue.pngThanks for your time

2 REPLIES 2
morr-co
10 - Fireball

Hi @fardeen9983 - my recommendation would be to update the macro to accept a record count parameter and to use that parameter to update a detour tool. This would bypass all of the tools if there is no incoming data. I've attached an example of what this might look like. The formula in the action tool is shown below and should update the DetourRight configuration.

 

IIF(ToNumber([#1]) = 0, "True", "False")

 

Screen Shot 2021-01-06 at 9.03.40 AM.png

hemant86
10 - Fireball

Hi @fardeen9983 Appreciate if you could attach the workflow 

Labels