Output to second excel tab - minus duplicate rows

[Baz123]

Hi,

I have a weird one to ask for help with.

Alteryx outputs my workflow to an excel sheet that overwrites the content each week for a new file.

I need to output the same data to the same file, but on a new tab with duplicates removed based on two columns (like in excel you can select duplicates removed based on columns A and B).

Can someone advise how to do this in excel as I cant seem to find an easy solution

:)

[binuacs]

@Baz123 have you tried the option Create New Sheet from the output tool?

For removing duplicate records you can use the unique tool

[Baz123]

Hi @binuacs

All good, I managed to sort it with a block until done, and add a unique tool that points to the other sheet.

Seems to work fine for now.

Thanks :)

[johnyli168]

Hey @Baz123,

To confirm you have two running sheets here;

- Sheet 1: Fresh data updated every week

- Sheet 2: Keeping a running total of unique values across two columns from the weekly data update

For Sheet 2, once you have the data updated every week, I would suggest looking at the Unique tool in the Help documentation or checking the example within your designer interface. The second part to this is making sure if both workflows are writing to the same excel is utilising Block Until Done to ensure you have all the data written in.

[Baz123]

Hi @johnyli168 

Yep, I have a template that is updated weekly on sheet 1. Sheet 2 is just a copy with duplicate lines removed.

I have done as you suggested and used the block tool with a unique tool to remove the duplicates and write to the second sheet.

Thanks. :)