Re: queryDef Script Instance Variable Problem!
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Classic
6.8K
1
3
Likes
Total Posts
Correct Reply
Hi Rob,In this case, the difference field should be populated as integer
default value 0 and should work fine.Thanks,Nainy Jain
Views
Like
Replies
Re: queryDef Script Instance Variable Problem!
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Classic
6.8K
1
6
Likes
Total Posts
Correct Reply
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
Views
Like
Replies
Re: queryDef Script Instance Variable Problem!
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Classic
6.8K
1
8
Likes
Total Posts
Correct Reply
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
Views
Like
Replies
Re: queryDef Script Instance Variable Problem!
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Classic
6.8K
1
10
Likes
Total Posts
Correct Reply
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
Views
Like
Replies
Re: How to populate a variable from JavaScript to a column in Data Extraction Activity?
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Standard
1.4K
3
1
Likes
Total Posts
Correct Reply
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
Views
Likes
Replies
Re: Can we store instance variable into an array?
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Standard
1.2K
2
0
Likes
Total Posts
Correct Reply
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);...
Views
Likes
Replies
Re: Campaign extension data schema
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Standard
931
1
0
Likes
Total Posts
Correct Reply
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.
Views
Like
Replies
Re: Introduce yourself
nainyjain
Employee
10 likes
8 posts
1 solution
Top badges earned
View profile
nainyjain
- Adobe Campaign Standard
7.6K
0
0
Likes
Total Posts
Correct Reply
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
Views
Likes
Replies
