Find common entries in two or more files

[#1]

Hi,

I've got three files

1. Master database of all dealers with sales of 2009 and 2010

2. List of dealers under 'blue' category of 2009 and

3. List of dealers under 'blue' category of 2010.

I want to compare sales of the dealers under 'blue' category who are common in both years.

Please help.

Regards,

Rahul

[#2]

use inner join. Like

table3:

inner join(category2009)

load * resident category2010;

hope it's helped

[erichshiino]

or you can just use left join to create flags on the dealers

Something like:

left join(mastertable)

Load DEALER, 'Blue2009' as Flag1

resident Category2009;

left join(mastertable)

Load DEALER, 'Blue2010' as Flag2

resident Category2010;

You can use those fields on the interface to select the selected deales, or use it on set analysis.

Hope it helps,

Erich