Append range is writing duplicate data in the excel

I am trying to append various data-tables in the excel sheet, but when i am using for each, then it is writing duplicate entries in the excel sheet, so how can this problem be resolved.
ex :
i have a datatable having the row
a,12,wer
so the output is coming
a,12,wer
a,12,wer
but it should only come
a,12,wer

So how to solve it?

@Aishwarya_Bhargava Are you going to Append the datatables to the same sheet ?

@supermanPunch yes

@Aishwarya_Bhargava In that case you can use Merge Datatable Activity to Merge All datatables to a Single Datatable and then use Remove Duplicate Rows Activity on that result Datatable and then Write the Datatable using Write Range Activity

1 Like

i cant use write range as it will override the data present in the sheet, i want the new data to be added at the bottom of the excel sheet.

@Aishwarya_Bhargava Then Instead of Write Range use Append Range. Outside the For Each Loop

Merge activity is not working, it gave an error

@Aishwarya_Bhargava Can you tell me which activity produces the output datasetResults ?

output data table

I don’t think it is this Activity :sweat_smile:, Are you by any chance performing Document Understanding or using Export Extraction Results Activity ?

Hi @Aishwarya_Bhargava,

To remove the duplicate in the excel you can use this activity…

Video

Thank you
Balamurugan.S

1 Like

This worked thankyou.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.