Frequently Asked Questions

Output



I can't delete the dupes in my file - the menu option is greyed out.

You can't delete the duplicates unless the Import and Find Matches processes completed normally. Repeat the job, by opening the input file again and proceeding as normal.


I can't output my file - the menu option is greyed out.

You can't output any data unless you have deleted matches, either via Inspect Matches or Delete Matches.


I don't want to delete records from my file - can I just mark them?

Yes. Select Output all records when prompted, or from the Output menu.


Can I write out a file of the records that I've deleted?

Yes. Select Output deleted records when prompted, or from the Output menu.


What format is the output file in?

The same file format and structure as the input file.


What field layout is the output file?

The output file is in the same layout as the input file, with an extra field for a deletion marker if you choose to output All Records.


Some of the fields in my output file are shifted over a column or two

This is probably because they were like this in your input file. If the input file is correct, then it may be that dedupeIT has not properly loaded the records in at the Import stage. If so, try saving the file in a different format e.g. if it is an Excel file, try saving it as a tab delimited file then opening that file in dedupeIT. Alternatively, a sample of the data.


What does dedupeIT do to my data - does it change it in any way?

dedupeIT preserves any amendments that you make to individual records in Inspect Matches. Other than this, it does not change your data, apart from removing or flagging duplicates. If you are flagging duplicates, it adds a field for the deletion flag. If you want to correct your data in other ways e.g. casing, postcodes, you can buy a more functional product from the helpIT systems' range, matchIT, to do this. For more information, visit www.helpit.com or .


Can I specify a different output format to the one the input file was in?

Not in dedupeIT. You can buy a more functional product from the helpIT systems' range, matchIT, to do this. For more information, visit www.helpit.com or .


Can I save my reports to file so that I can print them later?

Yes you can. When you run a report, an options screen provides options such as whether to preview or print the report, etc. To save the reports to file, you should select a report destination of File. More information about this is given in the User Guide and On-line Help.


Why do I get I/O Error 32 when trying to output my results?

This error can occur when the file that you want to output is already open. dedupeIT can't write to a file that is in use by another program. Either close the other program that is using the file, or change your output file destination to a new name.



 

See our comprehensive range of other professional data cleansing software products at