Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Counting Duplicates across multiple columns

Iggypop
8 - Asteroid

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 🙂

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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

 

Iggypop
8 - Asteroid

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

Labels