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 duplicat...

Hi @ParthaSarathy , I've added those in the identifcation of duplicated, but where do you tell Campaign to keep only the row where first and last name are not empty? But this actually, would only separate the duplicated from the no duplicated records, right? How would I tell Campaign to remove the d...

Hi, I've duplicated records in recipients table.The deduplication field would be: national_id, that is the one repeated. However, I just want to keep the record that have info in the other fields: first_name and last_name. How to remove the recoeds that are duplicated, based one national_id,  and  h...

hi. @ParthaSarathy , please, check edit 1 in original question.

Hi, I have a file.csv.gz that I need to read. It has the fields date_creation and date_modify with valus if I open it in excel, but when importing in Campaign, campaing gives error satying those fields are null.  Why?**Error:** 10/27/2023 9:04:16 PM PGS-220000 PostgreSQL error: ERROR: null value in ...

Thanks @Marcel_Szimonisz , last question: In your last image I don't see the channel field, but only email, sms, push. Should I remove it? Why was it added in the first place?Ty, 

Hi @Marcel_Szimonisz , how do you : Group by Channel and add expression for contact date YearAndMonth([scheduling/@contactDate]) give it alias e.g. @yearAndMonth and check the Group Thank you.

hi @Marcel_Szimonisz , I don't find the fields: I'm querying nms:delivery, but I don't find "contact date" or "channel". Please, could you elaborate on where to find them?  

Hi, who can we configure this rule for push deliveries: Tipology for for sending weekly 2 push to recipients?

Hi @Marcel_Szimonisz , why the first query has a : sent proof == No? Sometimes, our deliveries sent a proof before sending the message to final users. Is the first query: 1.- Excluding all the deliveries that used a proof before sending the final message? Or2.- Is excluding all the proofs only?