![]() If you let mDesktop allocate Unique References when the files were originally imported, you must make sure that the Unique References don't overlap between the files. Merge Files adds unique records from the Second File to the Main File. Purge Records does not change the Main File, but removes records from the Second File. The Main File is the first file you select. it is a superset of all the individual structures. If you are using the Multiple File Wizard to merge files, the wizard creates a master layout for you which preserves all of the data from the individual files i.e. If necessary, you should use Main File Layout from the Jobs/Setup menu to add or widen fields in the Main File. has one file got more address lines or wider fields? If so, make sure that the Main File is the one with more lines or the wider fields. Merge or Purge (for a suitable threshold score).īefore merging two files, the two Main File Layouts should be checked to pre-empt problems later on e.g.View/Verify the Overlap to check the matches found.The Basic Merge/Purge Process is as follows: You do not have to Find and Delete Matches from each individual file before running Find Overlap, but you must do so if you want the internal duplicates in each file removed! Thus purge is the same as merge, but stopping short of the final stage no merging takes place.Įach input file must have been Imported into a mDesktop Main File (using the Setup Wizard or Import records options) before you can do Find Overlap successfully. These two operations have much in common, and in fact when merging, mDesktop first purges records from the new file and then merges the remainder into the Main File. If, on the other hand, you do want to send the same letter to all existing customers and prospects as well, what you can do is to create a new file (or table) by "merging" the new list and your file of existing customers, eliminating (or not creating), any duplication. ![]() ![]() In this case, you need to locate any of your existing customers that happen to be on the new list, and "purge" them from it. Typically, you want to write to all the new prospects, but want to be sure you do not inadvertently send the same letter to any of your existing customers. The most typical use of Merge/Purge processing is when you have a file of existing customers and also an external list of prospective customers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |