Skip to Main Content
Forums

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!

Parsing in a Conditional Map Script

User_138K0Jun 19 2014 — edited Jun 19 2014

For the given script, any amount that is not zero, it will map to itself.

If the account comes in as 1234_5678_9101 and we want to map it to 1234.5678.9101, how would that appear in the fdmResult?

I've tried varying parsing functions and having no luck.

account = fdmRow.getString("ACCOUNT")

amount = fdmRow.getString("AMOUNT")

if (amount) == 0:

     fdmResult = "IGNORE"

else

     fdmResult = account
This post has been answered by User_138K0 on Jun 19 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2014
Added on Jun 19 2014
#business-intelligence-applications, #financial-data-management, #performance-management-applications
3 comments
1,577 views