Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ;
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!
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.
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!