Hi, I've 350K recipients that were wrongly put to quarantine. What table should I target to change their status from "Quarantine" to "Valid"? 

Please, see Update 1 and 2.

I've a schema in long format that needs to be converted to wide format. I've the schema with data on the left, and I want to create another schema with data, based on the original, but in wide format (right image). Is it possible? There are other fields, but I mainly care about the ones in the image...

So, I've a case where we need the values from "channel_of_comunication_id" from schema "comunications_preference" when filtering "recipients" schema (the OOTB recipients). I think, I have to ways to accomplish this:1.- Link "comunications_preference" schema with Recipients. 2.- Make an Enrichment in...

I need to now the unique elements of the column: DESCORREOAF from Recipients table. I used this query:SELECT COUNT(DISTINCT DESCORREOAF) AS DESCORREOAF FROM NmsRecipients;But is giving error: 27/09/2023 17:28:54 PGS-220000 PostgreSQL error: ERROR: relation "nmsrecipients" does not exist LINE 1: ...T...

Please, see edit 2. I did what you mentioned and it was a string column as expected. But apparently the error is somwhere else. However, error messasge is not clear.

Please, see edit 1.There is not SubString function applied, not by me.  Just added the last highlighted field.

Hi, how to debug this error? I was tasked with adding a new column to a table. So I:1.- Modified the XML of the schema to add this new column (attribute).2.- Updated DB Structure.3.- Configure fields on the Load activity.4.- Add the new field in the Update activity (Destination and Source Expression...

Hi, we can automate this with seed addresses to acomplish this?If so how?

Hi, text in proof is diferent from HTML, what could be the cause? Proof: Delivery in Campaign: