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
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 =
)var res =
query.ExecuteQuery()//Creating array to store ...
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