Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Data Management SQL script using a variable — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Management SQL script using a variable



We have ~10 scripts for conversion from VB (FDM classic) that use a temp variable based on a target custom member.  In this case the second segment of the target entity is stored in a variable and appended to the location which is based on the source account.  In some scripts there are thousands of combinations so multi-dim maps aren't feasible.  How can we define a variable in the mapping script?



Code Snippet

strSrcPlatform = varValues(16) 'get the entity
strSrcAcct = varValues(13) 'get the source account
strTarPlatform = """"   'set the initial platform to blank
strSrcC1 = varValues(19) 
strTarAcct = varValues(14)

If InstrRev(strSrcPlatform, ""_"") >0 Then ' check to make sure the entity has a platform at the end

     strTarPlatform = Mid(strSrcPlatform,InstrRev (strSrcPlatform, ""_"")) 'if the entity has a platform at the end, grab it and store this value

End If

Select Case strSrcAcct 'take the account and based on the value, choose which entity is the ICP

	Case ""04006000"",""04006323"", ""04006339"", ""04007000"",""04007323"" ,""04007339"",""05016000"",""05016323"" ,""05016339"" ,""05017000"",""05017339"" ,""07076000""  ,""07076323"" ,""07076339"" ,""07077000"" ,""07077323""  ,""07077339"" 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!