I merged 5 excel files, but every time I enter a new rule, the values are added repeatedly. How can i remove duplicate values in excel merge function ?
@kocyunus Welcome to Community!!
Can you explain more about your process and what activities are you are using.
share your flow if possible if not share as a snap
You will have to merge all the files and then remove the duplicates because while merging you won’t be sure which could be the duplicate data until and unless you consolidate all files.
1 Like
Welcome to the community
better would be merge the data in datatable and then use remove duplicates activity and then write to excel
cheers
1 Like