Hello !
I’ve seen tens of topics about duplicates management but my workflow seems to be very particular.
So to make long story short, I need to update a file managing the duplicates.
If my workflow is not optimal, feel free to tell me !
So I have a main file with few columns. I add a manual note in a dedicated column (this detail is important because it implies that I need to keep this file).
Each week, I download a bigger file (more rows and columns). Basically, it’s a kind of history. It does contain all of the records.
It looks like this (simplified version) :
I’ve made a base of the process which is there (Project .XAML) with dumb data :
TestUiPathForum.zip (69.6 KB)
In this example I chose to make a simplification because actually I have 3 sources with a lot of different column labels. But if I manage to do it once, I guess I’ll be able to do it again with other files.
The following figure is just detailing a little bit the process :
So what are for you, the best practices to manage duplicates with these context ?
Thank you very much !