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 🙂
