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
Solved! Go to Solution.
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:
Hope this helps : )
Thank you!
Happy to help : ) @Anastasio_Theohari
Cheers and have a nice day!