Comparing Data

[Anysia]

I have two data file using same dictionary, I am challenged with an issue that i wish this forum can assist me.
My Id items have the following fields
DEO ID
Cluster No
Household No

Two different DEO's keyed same cluster and Households, My challenge is anytime i compared the data i have case missing.
My investigation shows that if i change the DEO ID it works.I can compare the two same files. I need the DEO ID in my dataset.
The Data set is in thousands of cases it going to be a hell of a task to change all cases DEO ID to be same.
How do i resolve this challenge for easy comparison.

[bidhu]

One way is create a batch application that generates another data file from the existing data with Cluster and HH Number as ID variable.

[Anysia]

Thanks So much. I have another issue I want assistance to format the CSDiff - Text Viewer. I don't like the default output text viewer
For Instance the outpout text viewer look like this:

Have Case Id Input File Reference File

22 22 1 Inp: Trump
Out: Trumps

I want to format it so it look like this

Have Case Id Input File Reference File

22 22 1 Inp: Trump Out: Trumps

I try using Notepad +++ i could not find a way out. How best can i fix this formatting, please forum?