Copying data from one sheet to another

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

Workflow

Output

Accepted answers

binu_acs

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

BAckUpFile_012423.yxzp

All comments

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!

binu_acs

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

BAckUpFile_012423.yxzp

svyas

Hi @binu_acs,

This works! Thank you so much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703