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...
Hi, We have a requirement to add preheader in our Emails. Could you Please let me know how to add it? Below is the Sample email with and without preheader Regards,Pravallika.
Hi there,It's a simple task. I want to load from a source table to another table.In this case I am making a query by Activity Query on a table (source table) and then using Activity Update Data to insert it into the <destination table>, which is empty.The two tables have the same structure. But I st...
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...
Hi,Im using Adobe Campaign Classic.I have just created a transactional message but it only lets me add one email, but I want to add another one. Anyone knows how can I do it? Thanks in advance as always kind regards,Blanca
Hello All, We have custom schema for our implementation, where we have created Input forms for managing data.We have a requirement wherein we need to do certain checks, when the Delete Button is clicked. How can that event be captured, so that we can add custom code for checking few business logic w...
I don't know the proper way to handle dynamic code with multipe values. Can someone help me? This is the error I am facing when I use switch case in the delivery.i have attached the code and th error screenshot below.
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...
Hello, Is it possible to use conditional HTML formatting in a Transactional Email Template based off of an RT event value? I've been testing with something basic like this: <% if ( <%= rtEvent.ctx.email.@type %> == 'Order' ) { %>Your Order is en route<% } %><% else { %>Your Order is delayed<% } %> I...