2,4 M of records for broadLogRcpHowever, I don't know how should I test the performance with the workflow since the query cannot extract the XML field.I suppose you are suggesting to use the JS code you were talking about but I don't know how to implement it in this momentSalvatore

This is exactly how I was doing.What I cannot understand is why extraction WITHOUT the subject takes about 8 minutes, WITH the subject about 9+ HOURS.And I don't know if the extraction works fine because I never completed it.Thanks anyway,Salvatore

Hi Jean-Serge,Thank you for being responsive.How may I use this JS code (message.delivery.mailParameters.subject) inside an export template? Salvatore         

Hi, How should I export an XML field through an export job template?In particular regarding 'delivery subject' ([delivery/mailParameters/subject])I read a similar thread, but that wasn't clear for me.Any solution?SalvatoreJean-Serge Biron​Amit_Kumar​Vipul Raghav​florentlb​Adobe Campaign​

Do you know how to export an XML field like 'subject' ?

Hi,I have created a job template for EXPORT, in particular I am trying to export this data in a flat file (csv or txt).When I do execute the template and extract the data, I get these kind of errors ""error while parsing XML string"Anyone may tell me where I get wrong ?SalvatoreVipul Raghav​Adhiyan​...

Hi,Hopefully a simple issue:Making the division (or using a percent function) A = B/C such as A,B,C are "double" typed for some reason the result is rounded to the next integer.Iif(B=0, 0, (A*100)/B)orIif(B=0, 0, Percent(A,B)*100 )Example: B = 2C = 3Result A= 67.00Expected A= 66.66Any idea ?Adobe Ca...

I finally solved this issue thanks to your help and after many attempts!Here is my custom solution for anyone that might need:Workflow.1st query:2nd query:It does work fine!

Hi Jean-Serge Biron,I'm coming back to this task only to ask you if it's possible to append this tracking string NOT ONLY in the single delivery or template, but at platform/AC instance level.It's something the customer would like to do.Is it possible?Salvatore

I used the deliveryForward report as base but things aren't changed, rather I get even errors and I cannot see anything.1st activity:2nd activity" Please, may you confirm what is your source line? Delivery/DeliveryId or deliverySegmentsOTB /Dimensions key ? "Don't know what are you referring to, but...