Hi @ParthaSarathy , how do you get to this screen?   

Does anyone know how to create this table using a workflow? +------------+---------+------+-----------+| month       | emails | push | sms |+-----------+--------+------+-------------+| august       |     120 |     15 |  10 |+-----------+--------+------+-------------+| september |     233 |     12 | ...

Ok, this worked: Case(When(Length(customer_cic)=12,customer_cic), Else(' '+customer_cic))Thank you, Manoj. 

hi @_Manoj_Kumar_ , I'm getting this error with  that code:10/17/2023 9:38:07 AM PGS-220000 PostgreSQL error: ERROR: operator does not exist: integer == integer LINE 1: ...cional = case when char_length(W0.sCustomer_cic) == 12 then... ^ HINT: No operator matches the given name and argument types. Yo...

In order to match a Recipients column, I need to satisfay this conditions:1.- If customer_cic is length 8, then add 4 spaces at the begging. 2.- If customer cic is length 12, leave it as it is.I tried: Case(When(Length(customer_cic)==12,customer_cic, Else('    '+customer_cic)) But is giving me error...

My recipients codinternocomputacional has 04 white leading spaces for each value. My other source CSV's "customer_cic" , which is the key to make the match, has no leading white spaces. I cannot/should modify recipients. How can I add the 04 when doing the key matching?   

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