AnsweredAssumed Answered

Best strategy on merging files without duplicates?

Question asked by dcollins724067 on Feb 24, 2018
Latest reply on Mar 9, 2018 by dcollins724067

I have a question on how the best way to solve this puzzle. (normally, I am working with database sources, and so, I would use SQL to do the merging and sorting work.)

 

In this case, I'm working with two source CSV files, which I need to merge without accepting duplicates. Presently, my method is by adding the records to a document cache, and then saving that cache as a file.

Say like:

hile it does work, I'm thinking that you have a better way to do this work?

Outcomes