Show all name excluded in table 2.

[#1]

Good Day Sir.

     I like to show the all the person who did not receive bonus from year 2012 month july.

Table 1:

Name
Peter
John
Mayer
Mac
Cyril
Russel

Table 2: (This are the persons who will receive bonus)

Bonus
Peter
Mac
Russel

So the result will be

No bonus
Mayer
John
Russel
Total - 3

     Please give me some idea.

Thank you in advance

[swuehl]

I assume you want to see Cyril instead of Russel in No bonus table, right?

If you can do it in the script, try adding (after the LOAD of TABLE1 and TABLE2):

NOBONUS:

LOAD Name as [No Bonus] Resident TABLE1 where not exists(Bonus, Name);

Assuming that Bonus is the field name in TABLE2 and Name the field name in TABLE1.

[#3]

Good Day,

     Yes sir, but it does not work.

The No bonus have no output.

[#4]

Hi,

Just to clear, Is "Name" and "Bonus"  2 separate fields in a same table? or are they loaded from 2 separate tables?

if they are loaded from 2 different table then Mr swuehl's answer should be correct.

Regards,

Alex

[#5]

they loaded from 2 separate tables

[sivarajs]

Above should work dont know how you are using

Check the attached file ,that might be what you are looking for