Remove duplicated rows based on other empty fields
Hi, how do I remove duplicated rows from Recipient, where the key to identify the duplicated rows is the column "national_id" and we'd like to remove the rows where first_name and last_name are empty.
I think the deduplication activity only works on temporary results, and wouldn't remove the duplicated rows from Recipients, right?
Edit 1:
I tried to use a deduplication and then a delete activity, but , of course, the delete activity deleted both records with the same national_id, regardless if they had first and last name data.
