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

Data Investigation

Luk88kk
8 - Asteroid

Good morning,
I try to use a multi row formula to remove invalid values from my database.
For example, I need to remove values ​​from rows that:
1. have decisions but no dates;
2. there are dates but no decisions.

 

Luk88kk_0-1634713751748.png

 

The result should be like this:

 

Luk88kk_1-1634713854701.png

 

I am very much asking for your support.

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Luk88kk 

 

You use formula tool like below.

 

Workflow:

atcodedog05_0-1634714436558.png

 

Hope this helps : )

 

binay2448
11 - Bolide

Find attached solution for the same..

binay2448
11 - Bolide

Hi @Luk88kk ,

 

If our solution worked for you then please mark it as solution.

It will help others if they have similar problem.

Luk88kk
8 - Asteroid

Thank you very much, both solutions are great and have helped me take my work further. Thank you and have a great weekend.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Luk88kk 

Cheers and have a nice day!

Labels