Hi Rob,In this case, the difference field should be populated as integer default value 0 and should work fine.Thanks,Nainy Jain

Hi Rob,I am not able to reproduce the issue in my system.Please check if all the difference attributes are of type "long" or "double" in your schema.Thanks,Nainy Jain

Hi robertw937098 ,Please follow the syntax as below:I have calculated the average of 2 values, you can use below formula for 3 values:([target/@diff1]+[target/@diff2]+[target/@diff3])/3Also, you can see the average field(converted to Integer) in display target:Thanks,Nainy Jain

Hi robertw937098 ,The instance variable value is getting overridden in your script. It will always contain the average difference of the last customer.To calculate the average for each row, you can use the Enrichement activity using below steps.1. In "Add additional data", add a new output column fo...

Hi Sri Bhargav,Please use an Enrichment activity before data extraction activity to add a new "Primary Key" column in the temporary schema.Here, I have stored the primary key of the transient table in an event variable "vars.key". In the Enrichment activity, go to "Edit Additional Data" and add a ne...

Hi saishag86196293 ,saishag86196293You can store the query results in an array using for each loop in the query result and store it in vars to use it further in upcoming activities.Below is the code text:var query = xtk.queryDef.create(    <queryDef schema="xyz:transient" operation="select">        ...

Extension schema is just a view of source schema in which new columns will be added. Out of the box schemas in adobe campaign cannot be modified directly, but they can be extended and modified. All the columns added in the extension schema will be reflected in the source schema as they point to one ...

HiI am Nainy Jain from GMO team in Adobe. I have joined Adobe recently and my role is Associate Technical Consultant. I have 2 years of experience in Adobe Campaign Management and I look forward to learning and contributing to the community.ThanksNainy Jain