Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

nainyjain
Community profile nainyjain Employee
Job title here
Location here
8 BADGES
Employee

Employee

Learn more
Joined the community 03-08-2018 3:53:17 AM
Offline
Top badges earned by nainyjain
Customize the badges you want to showcase on your profile
Re: queryDef Script Instance Variable Problem!
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Classic
Hi Rob,In this case, the difference field should be populated as integer default value 0 and should work fine.Thanks,Nainy Jain

Views

7.1K

Like

1

Replies

3
Re: queryDef Script Instance Variable Problem!
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Classic
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

7.1K

Like

1

Replies

6
Re: queryDef Script Instance Variable Problem!
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Classic
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

7.1K

Like

1

Replies

8
Re: queryDef Script Instance Variable Problem!
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Classic
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

7.1K

Like

1

Replies

10
Re: How to populate a variable from JavaScript to a column in Data Extraction Activity?
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Standard
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

1.5K

Likes

3

Replies

1
Re: Can we store instance variable into an array?
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Standard
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

1.4K

Likes

2

Replies

0
Re: Campaign extension data schema
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Standard
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

1.0K

Like

1

Replies

0
Re: Introduce yourself
Avatar
Give Back 5
Employee
nainyjain
Employee

Likes

10 likes

Total Posts

8 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
nainyjain
- Adobe Campaign Standard
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

7.9K

Likes

0

Replies

0