Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Remove duplicate columns

JBATAIDE
7 - Meteor

Hi,

 

Is there a way to remove 'duplicated' rows if they match in certain columns?

The row to stay would be arbitrary (i.e. it can be the first one counting from the top)

Please see find an example in attachment

 

Thank you in advance,

Joao

2 REPLIES 2
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @JBATAIDE,

 

Is this what you're looking to achieve? I've "uniqued" on product and column 2 with the unique tool.

image.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

JBATAIDE
7 - Meteor

Thank you very much Jonathan! 

Labels