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

Skip the rows with same values and make nulls the other with different values group by

Anastasio_Theohari
8 - Asteroid

Hello,

How can i create a new field with null values if a column is different between the rows and keep only these with same value group by a specific column..

 

Lets say we have,

 

GroupID         Name

1                       A

2                       B

2                       B

2                       C

3                       T     

3                       T

3                       T

3                       T

4                       W

5                       K

5                       N

 

I would like this

 

GroupID         Name    NewColumn

1                       A                 A

2                       B               NULL

2                        B               NULL

2                       C               NULL

3                        T                 T

3                       T                  T

3                       T                  T

3                        T                 T

4                       W                 W

5                       K                   NULL

5                       N                   NULL

 

How can i create this new column?

 

Thanks

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Anastasio_Theohari 

 

Here is how you can do it. Use summarize to get distinct count join it back to data and apply logic to keep distinct count >1 as null

Workflow:

atcodedog05_0-1630408881940.png

 

Hope this helps : )

Anastasio_Theohari
8 - Asteroid

Thank you!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Anastasio_Theohari 

Cheers and have a nice day!

Labels