topic Re: How to delete records from QVD where FLAG=1 in QlikView

How to delete records from QVD where FLAG=1

vikasmahajan — Thu, 11 Feb 2016 06:53:33 GMT

Dear All,

I have ALLDATA.QVD with FileName as AssetTrackingAUG1,SEP1 etc also I have another table

Temp_FileNames with Flag . Now I want to delete records from QVD where Flag = 1 .

Help appreciated.

Thanks in adv

Vikas

Re: How to delete records from QVD where FLAG=1

MK_QSL — Thu, 11 Feb 2016 07:14:08 GMT

Not understood..

You have two fields... one QVD and one Excel.

You want to delete records from QVD where Flag = 1... is this Flag in both files or not?

Re: How to delete records from QVD where FLAG=1

vikasmahajan — Thu, 11 Feb 2016 07:17:04 GMT

Thanks for reply

I have 2 tables ALLDATA.QVD & Temp_FileNames with Flag (0 or 1) from ALLDATA.QVD i want to delete records

who's flag is 1

Vikas

Re: How to delete records from QVD where FLAG=1

MK_QSL — Thu, 11 Feb 2016 07:18:17 GMT

What is the common field between them?

Re: How to delete records from QVD where FLAG=1

vikasmahajan — Thu, 11 Feb 2016 07:21:19 GMT

FileName

Re: How to delete records from QVD where FLAG=1

MK_QSL — Thu, 11 Feb 2016 07:24:14 GMT

FileName is the QVD name or its a field in QVD?

if it is a field in QVD,

T1:

Load * From QVD...
Left Join

Load FileName, Flag From ExcelFile;

NoConcatenate

T2:

Load * Resident T1 Where Flag = 1;

Drop Table T1;

Drop Field Flag;

Strore T2 into T2.qvd(QVD);

Re: How to delete records from QVD where FLAG=1

tresB — Thu, 11 Feb 2016 07:25:35 GMT

Try like:

Tab:

Load

From ALLDATA.QVD (qvd);

Inner Join

Load

From Temp_FileNames.qvd (qvd) where Flag =0;

Store Tab into ALLDATA.QVD (qvd);

Drop table Tab;

Re: How to delete records from QVD where FLAG=1

vikasmahajan — Thu, 11 Feb 2016 08:07:14 GMT

Thanks Manish

I use tresesco's approach.

Thanks all

Vikas

Re: How to delete records from QVD where FLAG=1

MK_QSL — Thu, 11 Feb 2016 08:54:46 GMT

Obviously tresesco's approach is better than my approach.

Let me explain you one more scenario..

Consider that in QVD you have below filenames.

FileName

FileName1

FileName2

FileName3

FileName4

and in Excel file you have

FileName Flag

FileName1 1

FileName2 0

FileName3 1

Now using both of our reply (my one and Tresesco's reply) you will miss FileName4.

You can use below to get FileName4 also in your final QVD.

T1:

Load * From QVD...
Left Join

Load FileName, Flag From ExcelFile;

NoConcatenate

T2:

Load * Resident T1 Where Flag <> 0;

Drop Table T1;

Drop Field Flag;

Strore T2 into T2.qvd(QVD);

If you have exact match of FileName in both tables, you should use tresesco's reply !