Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
21 - Polaris

Hi @Mario36 

 

Please share the data in an input excel file.

Mario36
8 - Asteroid

Hi @atcodedog05 

Here you go

atcodedog05
21 - Polaris

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
21 - Polaris

Happy to help : ) @Mario36 

Cheers and have a nice day!

Labels