On Adobe campaign Classic , can i extend the nms:eventHisto table and save additional columns that might be passed by the source system. There is an XML column , but I still want to extract out and place this as a regular column that i could use. Please note that this i want to do on the campaign side and not sure how or will it impact anything with message center.
Thanks
Chez
Solved! Go to Solution.
Views
Replies
Total Likes
Hello @chez_elam,
yes you can extend the schema as any other schema. But then you will need to amend the synch workflow to add data to your new column.
The change has to be done on execution instance as well as on the control instance.
Marcel
Hello @chez_elam,
yes you can extend the schema as any other schema. But then you will need to amend the synch workflow to add data to your new column.
The change has to be done on execution instance as well as on the control instance.
Marcel
Hi @chez_elam ,
Yes you can extend the schema.
Or
You can fetch the xml element value from the 'data' field column. Let's assume the xml element you want to fetch is 'phoneNo'. Use query activity on 'nms:eventHisto' table and in 'Add Additional Data' add a column name 'phoneNo1' and use below syntax to define it:
Substring(data, Charindex(data, '<phoneNo =" '), 10);
Thanks,
Jyoti
Hi @chez_elam,
Were the given solutions helpful to resolve this query or do you still need more help here? Do let us know.
Thanks!
Views
Replies
Total Likes
Views
Likes
Replies