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!

Alteryx Designer Desktop Discussions

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

Change field values based on a condition

Mario36
8 - Asteroid

Is there a way to achieve the below ?

The logic is, on any given column if there exists a value '1' then the next columns need to be blank or null.

Mario36_0-1635176451687.png

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Mario36 

 

Please share the data in an input excel file.

Mario36
8 - Asteroid

Hi @atcodedog05 

Here you go

atcodedog05
22 - Nova
22 - Nova

Hi @Mario36 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1635183603945.png

 

Hope this helps : )

 

Mario36
8 - Asteroid

@atcodedog05  Awesome. This helps. Thanks much

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Mario36 

Cheers and have a nice day!

Labels