Hello Ramesh babu S  , Goldraj Samuel Dhinakaran , Dominik Wnuk , Parmeshwar Reure , Jeeshan , Kuldeep Singh ,Abhinav Singh  Please find the attached Adobe Campaign Developer Expert exam toolkit for the second week. This week's toolkit covers the following topics:About schema reference: Learn how to...

Hello @god_prophet,  Can you please clarify if you would like to do this conversion with the SQL code activity direclty or if you would prefer to use multiple Adobe Campaign activities?  If you want to do directly using SQL code please try the following steps: Add only SQL activity.Try the following...

Hello @god_prophet  I think, the error is in the SELECT clause. The STRING_AGG() function requires that you specify a delimiter for the concatenated string. In your query, you have not specified a delimiter, so PostgreSQL is throwing a syntax error.To fix the error, simply add a comma and a single q...

Hello @god_prophet , 1. First create a new field in the comunications_preference schema to store the recipient ID.To do this, open the Schema Editor and navigate to the comunications_preference schema. Then, add the following code to the schema:<attribute label="Recipient ID" name="RECIPIENTID" type...

Hello @rasiksj0311,  Please try the following code in HTML : <% var currentDateMinus30 = new Date(); currentDateMinus30.setDate(currentDateMinus30.getDate() - 30); %> <p><%= formatDate(currentDateMinus30, "%2D/%2M/%4Y") %> </p>  I tried this code and it is working. PFA Screenshot:  Kr,Parvesh 

Hello @acc_acs , The error message WKF-560029 in Adobe Campaign Classic means that there is some issue with the reconciliation key in the Update activity. 1. As I understood  first you used a query activity and read the data from source table.Notes: Just make sure you have a primary key in your sour...

Hello Ramesh babu S  , Goldraj Samuel Dhinakaran , Dominik Wnuk , Parmeshwar Reure , Jeeshan , Kuldeep Singh ,Abhinav Singh, Please find the attached Module 1 toolkit.This toolkit contains all of the resources you need to get started with Module 1 of the Adobe Campaign Community Mentorship Program 2...

Hello @Shruti1, The error message ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'default' to run this query. SQLState: 37000 indicates that the SQL Server server does not have enough memory to run the query that Adob...

Hello Ramesh babu S  , Goldraj Samuel Dhinakaran , Dominik Wnuk , Parmeshwar Reure , Jeeshan , Kuldeep Singh ,Abhinav Singh   Hope you are doing well! Welcome to the Adobe Campaign Community Mentorship Program 2023. Here are some resources that I believe will be helpful as you prepare for your Adobe...

Hello @god_prophet , It is also explained on the below documentation how index works.Data model best practices | Adobe Campaign  Hope it will be useful.  Kr, Parvesh