Hello All,
The unique tool won't work in the scenario I have, and hoping to find another relatively simple way to do this. I'm looking to remove a duplicate within a given row, but the column headers are all different. So if in a row, a "Corrected By HR Id (1,2,3 or 4)" has the the same number in it, to remove that number from the row. In the example below I need to remove in the row for id 2, to remove the number in the last column, and in the row for id 5, to remove the number in the Corrected By HR Id2 column.
Hope this makes sense...and thank you!
What I have | ||||
id | Corrected By HR Id1 | Corrected By HR Id2 | Corrected By HR Id3 | Corrected By HR Id4 |
1 | 10006979 | |||
2 | 26997 | 10006596 | 10006979 | 10006979 |
3 | 10006979 | |||
4 | 10006979 | |||
5 | 10006979 | 10006979 | ||
What I want to have | ||||
id | Corrected By HR Id1 | Corrected By HR Id2 | Corrected By HR Id3 | Corrected By HR Id4 |
1 | 10006979 | |||
2 | 26997 | 10006596 | 10006979 | |
3 | 10006979 | |||
4 | 10006979 | |||
5 | 10006979 |
Solved! Go to Solution.
Hey @kas,
Here is one way to do this using the transpose tool and summarize:
This solution uses the transpose and cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done
Any questions or issues please ask :)
HTH!
Ira
No worries @kas glad it worked for you 😄