Copying data from one sheet to another

[svyas]

Hi, 

I am new to alteryx. I have an excel sheet(sheet 1) wherein the data in updated automatically everyday and some of the old data is deleted. I want to automate the data transfer from Sheet 1 to Sheet 2 without deleting the old data in Sheet 2. I have tried to use Append but it keeps adding duplicate data. I have also tried unique and overwrite which deletes the old data. Help is appreciated.

-Thanks

[ShankerV]

Hi @svyas 

Any possibility to share the input and expected output please.

That will give better clarity how the output is expected in sheet 2 when sheet 1 data changes.

[svyas]

Hi Shanker,

The output in sheet 2 is supposed to be similar to sheet 1. It's just that I am able to copy  the data from sheet 1 to 2. But when the old data is deleted in sheet 1. Same old data also gets deleted in my sheet 2. 

Thank you for your response!

[binuacs · Accepted solution]

@svyas One way of doing this, is first read both your new Sheet1 data and existing Sheet2 data, union then write into Sheet2

[svyas]

Hi @binuacs,

This works! Thank you so much!