Joining without double entries for output

[#1]

Hi All,

I just want to know what should I do to join two qvd files without having a double entry for null values. Here is my example:

I have two qvd files. I used left join in loading the two qvds.

qvd1

DOCNUM	Amount
1	10.00
2	20.00
3	30.00

qvd2

DOCNUM	tag
1	a
	b
2	a
	b
4	a

I created a table box to view what I created and this was the result:

DOCNUM	Amount	tag
1	10.00	a
1	10.00	b
2	10.00	a
2	10.00	b
3	10.00	a

How will be able to eliminate double entrieswithout deleting the column tag. Thank you very much.

[sivarajs]

use LOAD DISTINCT while loading the qvds