Exclude data from table load script

[#1]

Hi

I have table A and table B loaded from QVD and I want just to stay with the values that just appear in A and not in B

[sunny_talwar]

May be this:

TableB:

LOAD KeyFields

FROM B.qvd;

TableA:

LOAD KeyFields,

          OtherFieldNames

FROM A.qvd

Where not Exists(KeyFields);

DROP Table TableB;

[#3]

Thanks It work

[sunny_talwar]

Great

[Anonymous]

Hi Sunny, thanks for the explanation.

I would like to know how should I do if I have the following fields:

ID#	Doc#
1	333
1	444
1	555
2	333
2	444
3	333
3	555

So I want to exclude all ID# that has Doc#555.

And result shoud be a table with ID#2

Is there any way to achieve it?

Thanks

[sunny_talwar]

You can try like this:

Table:

LOAD ID#,

           Doc#

FROM ....;

Right Join (Table)

LOAD ID#

Where Count = 0;

LOAD ID#,

           Count(If(Doc# = 555, Doc#)) as Count

Resident Table

Group By ID#;