Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use LOAD DISTINCT while loading the qvds