Remove duplicate records based on two columns

[timothyyeo]

Hi All,

I have a set of records and would like to remove duplicate values based on two columns.

Document No	Invoice No
123	1
456	1
123	2
456	2

The correct set of records to be returned should be:

Document No	Invoice No
123	1
456	2

In other words, the invoice number  cannot be repeated. If Invoice Number 1 has already matched to Document No 123, then it should not be matched again to Document No 456.

How can I do this in Alteryx? Using the unique tool either on both columns or one of the columns does not work.

[JoeS · Accepted solution]

Hi @timothyyeo 

It looks like you may be opening the macro and running it as a workflow.

An iterative macro is designed to be used as a tool itself.

I have attached a workflow that uses the macro within it. 

This then achieves the output that you wish.

There are lots of different resources available on the community about macros. I'd recommend starting with these:

this first

then this

[timothyyeo]

Thanks @JoeS . Good articles on building macros.