I have duplicate values. However, I only want to remove the ones that have a value other than 0 in a different column. For example
gsfaid countryname NumOpens NumClicks Unsubscribed
1-2ST5FQ 1 Chile 0 0 FALSE
1-431WTR 0 COSTA RICA 1 0 FALSE
1-431WTR 1 COSTA RICA 0 0 FALSE
the second row and third row have the same value. However I only want to remove the thirs since it has 0 under number of opens.
Thanks for your help.
Bookmarks