AnsweredAssumed Answered

Create list of unique records after comparing two files

Question asked by AllenFuller on Jul 8, 2014
Latest reply on Jul 8, 2014 by philmodjunk

Title

Create list of unique records after comparing two files

Post

     I'm new here and apologize if this has already been covered. I've read several related threads, but none that seem to address this issue...

     I have two files of contacts that are largely duplicative. Each contact has a unique ID. In theory, I would like to add both as separate tables in an FM database (I'm using FMPro Advanced 13), then create a list of the unique contacts from List A that are not in List B, and also a list of unique contacts from List B that are not in List A.

     Basically a diff file.

     Is this possible using an FM script, or do I need to a separate software? If an FM script, any suggestions on how to build it?

     Thank you for a novice question! Looking forward to getting to know FM better.

Outcomes