Deleting rows from QVD

[#1]

Hi All,

I have a QVD which contains 3 fields.

ID	Name	Age
1	AAA	10
2	BBB	20
3	CCC	30
4	DDD	40
5	EEE	50
6	FFF	60
7	GGG	70

I have and excel which contains ID.Now i need to delete all the ID's from my QVD which are there in excel.

Excel:  

ID

1

2

3

4

5

Final data in QVD should be only 2 entries (ID= 6,7).

Regards

Roopesh

[Aurelien_Martinez]

Hi,

//You can load your Excel file :

Load

ID as IDXL

From MyExcelFile

;

//Load your QVD

QVD:

Load

*

From MyQvd

Where not Exist(IDXL, ID)

;

STORE QVD into MyQvd;

//I think it's work