Appending Data - No Duplicate or Data Repetitions

Question

Hi,

I have a workflow and I am working with two files. I am appending the data to the other existing file which is the "time_mist_analysis". The only problem I have is that when I run the workflow twice, it creates a duplicates. And when I delete the duplicates and run it again, it created another duplicates with blank spaces in between.

Can someone help me by providing me a workflow that will avoid this kind of dilemma.

Attaching excel files for your reference. The data is coming from "time_mist 20240822".

Hope to hear from anyone,

Kamen

time_mist 20240822.xlsx

time_mist_analysis .xlsx

binu_acs · Answer

@KamenRider it is not append, if you append and run second time then the duplicate will come , so I union the data and removed the duplicate and writing to the analysis tab using the over write option . Check the workflow I sent you was working for you or not ?

KamenRider · Answer

Hi @binu_acs

Thanks for the response. I was able to mimic your workflow but received an error when I attempt to open the excel file.

Are you appending the data to the original file or you are creating a new file? The requirements provided to us is to append it to the time analysis file.

Please advise.

Kamen

binu_acs · Answer

@KamenRider

agg_29082024.yxzp