Counting Duplicates across multiple columns

[Iggypop]

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 🙂

[JosephSerpis · Accepted solution]

Hi @Iggypop I mocked up a workflow let me know what you think?

[Iggypop]

Exactly what I was looking for! I can't believe I didn't think to just use a summarize.....ugh.