Job is merging extra records that aren't in the database.
A job may merge more records than expected if the database is not in a plain delimited text file format, if there are empty lines in the database file, or if the job's DDF does not have appropriate settings. To determine why your job is merging unexpectedly, follow these steps:
First, open the database file in a plain text editing application (for example, TextWrangler or Notepad) to confirm the file is in a plain delimited text file format and to examine the file for extra Line Ending characters (these characters may be displayed by your text editing application as an unknown character, for example, as an "¿"). Also, determine which character is being used as a Field Delimiter and examine the file to see if any quote marks are being used as a Text Qualifier. When finished, close the file.
Then, confirm the following settings in the document's DDF:
- Confirm the Database Definition's (DDF's) File Origin setting is set to Auto-Detect or matches the file origin of the database file.
- Confirm the DDF's Field Delimiter setting matches which character is being used in the database file as a Field Delimiter.
- Confirm the DDF's Text Qualifier setting is accurate. For more information about selecting the correct Text Qualifier setting, see the Unexpected quote mark or inch mark in Links? Knowledgebase Article.