Hello,
We have a situation where we need to update the country for a recipient dynamically in the workflow through the update data activity,
Though we map the country field to the value we need, it's not updating.
Scenario:
Each of the recipient may have different country.
can someone please help us on this.
Solved! Go to Solution.
Views
Replies
Total Likes
The field country is a linked object (nms:country) to the recipient.
Link condition is the location/@countryCode which is supposed to contain the ISO2 country code defined in the country table.
i.e. you need to set the country code within the Update Data activity.
Views
Replies
Total Likes
The field country is a linked object (nms:country) to the recipient.
Link condition is the location/@countryCode which is supposed to contain the ISO2 country code defined in the country table.
i.e. you need to set the country code within the Update Data activity.
Views
Replies
Total Likes
There are two attributes iso2 and iso3 for countrycode .How will these two type of codes will be updated in a single countrycode attribute.
Views
Replies
Total Likes
As mentioned in the post, the field in Recipient to update is the location/@countryCode whihc is the ISO2 code...
Thanks
Denis
Thank you for the clarification. Can we do it by enrichment. If yes, Can you guide me through.
Views
Replies
Total Likes
Views
Replies
Total Likes
I am a bit confused by your workflow:
You do a query on nms:recipient to get get a list of recipient --> fair enough.
How do you get the country code you want to update these recipients, do you bring it in Additional Data?
The field to update is simply @countryCode in the destination of the Update activity.
Thanks
Denis
We do not have country code in the csv data file, but having country column .We want to populate country code from country column in existing attribute , please let me know how can we do the same
Views
Replies
Total Likes
What is the format of the country in the file? Is it ISO2 value or is it just the country name itself?
Thanks
Denis
Firstly, the format of country in csv file is country name itself. I want to map the isoA2 and isoA3 values from the country column itself.
P.S I have extended the recipient schema and created a country attribute. I want to do it by enrichement.
Views
Replies
Total Likes
If you have the field in your CSV and the new field available in the Recipient entity, in the Update activity, you just select the field from the CSV in the Source section and you select the new field from the Recipient entity in the Target section...
Sorry I might miss something but I don't see where your issue is really
Thanks
Denis
I tried mapping country (csv file)with the country Code(@location/countryCode). It is working fine, but when i tried to map country with isoA2(country.@isoA2) , its throwing errors.
Views
Replies
Total Likes
O i see, you can't map it to the field within the link if the link doesn't exist yet, so you can't map the field directly on country.@isoA2 because the link"country" does not exist yet.... Check the link definition on nms:recipient
That's the reason you put the ISO2 from your file into the field "location/@countryCode" because it does build the link field...
Hope this clarifies,
Thanks
Denis
This is how i tried to do, but it gave me error.
Views
Replies
Total Likes
Resolved it, Thanks
Views
Replies
Total Likes
Views
Likes
Replies