topic How to delete a record based on multiple column values. in QlikView

How to delete a record based on multiple column values.

Vishal — Wed, 27 Jul 2022 19:33:25 GMT

Hello Everyone,

Thanks for helping me in advance!

I need to replicate a SAS code in Qlikview, wherein I need to delete certain record if multiple columns have certain values. Please refer to below example. Please help me resolve this!

if ACCOUNT_NAME in ("ABC") and ndc_nbr in ("000123") and datepart(ship_date) = '14SEP20'd

then delete ;

Re: How to delete a record based on multiple column values.

ASEDavidSu — Thu, 28 Jul 2022 02:32:17 GMT

I have a method that is filter the data that you don't want to present.

Here's an example bellow.

before:

after:

First, filter year(2022) and month(11) that I don't want to present, change its value as 0.

Then, load a new table and use "where" to filter the column that is bigger than 0.

You can take it for an example above.

Hope it helps.

Re: How to delete a record based on multiple column values.

Vishal — Thu, 28 Jul 2022 07:22:12 GMT

Thanks ASEDavidSu! I appreciate your response, this is certainly helpful.

I have solved it another way. Here is how I have done it -

I clubbed all the necessary columns in one, then in next resident load I filtered the combination I wanted to delete, and later dropped the column. Please refer the above screenshot. Thanks!