How to delete a record based on multiple column values.

[Vishal]

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 ;

[ASEDavidSu]

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.

[Vishal · Accepted solution]

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!