Hi Partha,I think you can use SQL calculated fields here . Something like:<attribute expr="[SQLDATA[case when iRank = 0 THEN '3' when iRank is NULL THEN '3' ELSE 'Specified'END]]" label="rank" name="rank" type="long"/>Or you can delete the existing data and and reload the schema with the updated con...

Hi Clarence,Attachments are not yet supported in ACS.Regards,Adhiyan

Hello Gael,In that case , simply select  the operation as INSERT in the Update data activity (Database /newcomers for you) .If you try to enter a email ID already present , it would throw an error .Regards,Adhiyan

Hi Gael,You can add a deduplication before you upload the data.The workflow should look like this.Inside the deduplication , you choose the columns where you want to deduplicateRegards,Adhiyan

Hi Tom,Sorry . Your message appeared in the standard forum hence forwarded you the ACS doc.Can you simply try this :<%if ( recipient.firstName == "" ) {%>You're almost there!<%}else {%> <%=recipient.firstName %>, you're almost there!<%}%>Regard,Adhiyan

Hi Tom,You can use the dynamic text option in ACS to define two different variants based on whether a condition is fulfilled.The product itself will handle the IF ELSE conditions in doing this.Please check here on how to make this work in detail : Adobe Campaign Help | Defining dynamic text Regards,...

HI Thomas,What is confusing me is that the preview of the data that you see , has the deliveries listed that has a label Buy but ideally it should return the recipients. Like this .But in your case I see the deliveries belonging to nms:delivery being returned. So I suspect a problem with the targeti...

Hi Thomas,Which Filtering and targeting dimension have you used in the query. Are you filtering on BroadLogRcp.You should ideally select filtering as broadLogRcp and targeting as Recipient for this purpose and the filter should look like.If you want to check if the formatting of the word buy is caus...

Hello Thomas,In general, the broadLogRcp table stores the delivery logs and trackingLogRcp stores the tracking logs. This however can be changed from the target mapping used in a delivery.You can verify this by clicking on "To" in the email editor and check the target mapping. In this target mapping...

Hello Adithya,The script is correct if you are just trying to see the no. of files in that location. If you want to know the names of the file along with last modified date, please add the following lines to the code :// Scroll through every file and log its detailsfor each(var objFile in objFiles){...