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
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.
