Hi Alteryx Community.
I am building a data quality workflow and having a hard time trying to do a count of duplicates across multiple columns. Sure I could just use several unique tools for each column, but the problem is when we get to data sets with thousands of columns.
I've included a data set with duplicate values in multiple columns. I am looking for a way to do a count it for each column, and provide me the total for each column in a separate column. I have looked at some many posts about this, but they are all variations of removing duplicates, counting duplicates in single columns or other variations, but have not found a solution for my specific need.
Please help 🙂
Solved! Go to Solution.
Hi @Iggypop I mocked up a workflow let me know what you think?
Exactly what I was looking for! I can't believe I didn't think to just use a summarize.....ugh.