Curious- why are you not using the CRM Publisher to detect Insert, Update as they happen to the Product entity, and have another one to listen for Delete on the Account Product entity
Yes, this is possbile, just need to make sure you use double quotes for all the strings (your Y was in singles);
IF(S1 = "Y", "1", IF(ISEMPTY(S2), "3", "2" ))
You can try DTSEdit.exe and change it inTarget Tables...Not sure how supported this is, so of course use a Copy first to test...
Some misc info on how to use the tool:
https://community.dynamics.com/crm/b/crmpowerobjects/posts/copying-scribe-target-steps-using-dtsedit
Thanks, I did try other browsers and kept them open for at least 4 hours while at work. It would stop at different maps. Shrug!
After the project was completed, I ended up just copying them into separate solutions just to get the documentation.
This response might be too late, just now seeing this, but remove those spaces within the quotes. It needs to be an exact reference
DBLOOKUP2(S2 , S3 , "nwksql3 - temp", "SubMarketConversion", "PrimaryMarket", "SubMarket", "NewSubMarket" )
We are using the Google Docs - Documentation Tool to document a solution with 26 maps but it keeps stopping in the middle of the 16th map. Anyone else experience a limit on this tool I'm checking the source code but don't see a hard setting for this. I really don't want to export some maps then import them into a side solution just for extractingdocumentation.
https://dev.scribesoft.com/en/g_docs/doc_maps.htm
They just posted this which might be helpful to at least make sure the services are running:
https://support.tibco.com/s/article/Programmatically-Start-Scribe-Insight-Services
Have you been able to figure this out I'd be interested since I have seen on very rare occasions where one or two scribe services stop for some unknown reason but then start up once I LOG INTO the server. Have you tried assigning your user as the services account to see if that reveals anything Guessing you already scanned your server Event Logs.