How to use the smart service to write to 1 sheet first with CDT data followed by need to update Sheet 2 on the same Excel.
The template used has 2 sheets on it.
All i am looking for is updating excel template with 2 sheets needs to be updated with values from CDT.
I had tried using same smart services twice
1 smart service configured to update Sheet 0
2nd smart service Configured to update Sheet 1 and have provided value for "Document_to_override" with the output of the 1st smart service (document datatype)
Discussion posts and replies are publicly visible
I was able to resolve the issue,
on the second smart service updated "Excel_base_template" parameter with the first smart service output document.