So, this would exclude all the emailcomercial or celularcomercial empty rows, allowing only to pass the rows with emailcomercial or celularcomercial not empty. Therefore, if all values in emailcomercial or celularcomercial are empty, the workflow would end?I just want to make sure that if emailcomer...

I have a Recipients tablet extension. It differs in the namespace with the default recipients table: abc:Recipients vs nms:Recipients.I've added columns: flag_correo and flag_sms to abc:Recipients, they are empty. abc:Recipients already has column "codigointernocomputacional" on this table with data...

Hi, I've an importer that loads a CSV in order to fill  a table (schema). We're currently using a test activity to test if there is full data on all columns, but how to do the same of only 1 or n columns?Our current test activity content: vars.recCount > 0 how to do test : if "emailcomercial" is emp...

I have many deliveries in a Campaign, they all have the same label, since it is a recurring delivery. However, the differ in the DM part. Example: J_NEWUSERS (DM533015), J_NEWUSERS (DM537239)... and so on. Since I cannot filter by label because the have all the same label. How can I filter by DM in ...

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.