Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Script at Data Load Mapping

Moatasem SheblJan 10 2017 — edited Jan 10 2017

Hello all,

I am trying to write a simple mapping script at fdmee using #SCRIPT

The script concept is :

If the entity source  = the IC source the reuslut will be "No partner"

else the result will be ICP_The IC values

i mean

Entity - Source  (company)       IC - Source               IC - Target

100                                           100                         No Partner

100                                           101                        ICP_101

Note : IC is a dimention at my target application

I write my script at data load mapping page at IC dimention as that

company = fdmRow.getString(“ENTITY”)

IC = fdmRow.getString(“UD12”)

if (company == IC):

fdmResult  = 'No Partner'

else:

fdmResult = IC

it did not work with me and i got that error at my log file

File "<string>", line 2048, in updateTDATASEG_T_TDATASEGW

UnicodeDecodeError: 'ascii' codec can't decode byte 0x1c in position 36: ordinal not in range(128)

This post has been answered by SH_INT on Jan 10 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2017
Added on Jan 10 2017
2 comments
263 views