Multi Data Source with Excel template?
My understanding is that since the Excel template calls the SmartConnect web service, the data sources defined in the map are not actually used, and that only the data submitted from Excel can be processed–so I’m assuming that any additional sources defined in a Multi Data Source will not work. Is that accurate?
Big fan of your work and your blog!
Yes you are 100% correct. When you pass in the data via the web services, it entirely replaces the source data from the map itself.
So without sending in the “extra source data” from the multi datasource queries – your map would (try to) run the map without that data since it won’t be queried.
Hi Patrick, thanks for the quick response!
This customer runs almost all of their maps using the Excel templates, so unfortunately they won’t be able to utilize many of the source data features of the maps.
I’ll try some script in a calculated field on the destination map as an alternative.
If you would like to submit an answer or comment, please sign in to the eOne portal.