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 for average.2. Go to "Advanced Selections", then
"Expression"3. You will see the list of all the available functions.4.
You can use sum and calculate the average.Thanks,Nainy Jain
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 new output column to store the key.After this, you will
be able to see "Key" in the Data Extraction activity as available
columns and add it to the export file.Thanks,Nainy Jain
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(
)var res =
query.ExecuteQuery()//Creating array to store all Id'sid = []for each
(var t in res.transient){id.push(t.@id)}logInfo('id array' + id);//Store
id array in vars to use it in next activitiesvars.idArray =
id;logInfo('vars.idArray ' + vars.idArray);...
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 schema in the database.
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
