Append Range Data getting duplicated

Learn Academy Feedback
#1

I am trying to extract data but the data is getting duplicated in Append Range Data

Append range
#2

Hi @Mohit_Jain

Welcome to the community!!!

There can be two scenarios here.

  1. Excel already has the data you are trying to insert
  2. The datatable already has duplicated values

For scenario one
Read the excel and combine with the data table you are trying to insert, and then use a remove duplicates in data table activity to remove duplicate records. The do a write range to write all the records both existing and new

For scenario two
Use a remove duplicates in datatable activity before appending the datatable to the excel

Hope it helps

2 Likes
#3

I think i am unable to explain, Can we connect over a screenshare ?

This is what i am doing as of now:
Open Browser → Excel Application Scope → Do Read Range → Read Range → For Each Row → Body → Write Line → Data Scraping → Append to CSV.