nainyjain

Re: queryDef Script Instance Variable Problem! - 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

7.1K

Re: queryDef Script Instance Variable Problem! - 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

7.1K

Re: queryDef Script Instance Variable Problem! - 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

7.1K

Re: queryDef Script Instance Variable Problem! - 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

7.1K

Re: How to populate a variable from JavaScript to a column in Data Extraction Activity? - 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

1.5K

Re: Can we store instance variable into an array? - 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);...

1.4K

Re: Campaign extension data schema - 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.

1.0K

Re: Introduce yourself - 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

7.9K

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe