Can anyone help me Paste here Jython script on below requirement.
I would like to wirte BefImport script as to import the data from open interface table for below reason
one of Business unit is coming with " 01020-XXXX-SBL "
In HFM It is "XXXX" only
I have given Like mapping as " * to * " for Entity in FDMEE, obliviously it will fail since source and target members are different
I request from community experts for Jython script as to import only Middle 4 characters from AIF_OPEN_INTERFACE Table from column "COL01" (Where entity is stored)
Thank you in advance
If your source codes are a consistent length you code use FDMEE character stripping expressions in your LIKE map i.e.
Source Value = ??????*????
Target Value = *
For " 01020-XXXX-SBL " this would return XXXX as the target - no need for scripting