(214) 614-8289
2591 Dallas Parkway, Suite 300, Frisco, TX 75034

Blog

The most interesting recent blog entries

FDMEE Conditional Map Script Examples

Here are just a few examples of how conditional map scripts can be used in FDMEE.

Example 1

If you need to ignore any lines with amount of $100, and map the rest of the Account members to itself for target…

account = fdmRow.getString("ACCOUNT")

amount = fdmRow.getString("AMOUNT")

if (amount) == 100:

fdmResult = "IGNORE"

else

fdmResult = account

 

Example 2

If you need to ignore any lines with amount of $100, and map the rest of the Account members to itself for target with a different delimiter, for example, Source: 0123_5678_10110 set to Target: 0123.5678.10110

account = fdmRow.getString("ENTITY")

amount = float(fdmRow.getString("AMOUNT"))

if amount == 100:

fdmResult = "IGNORE"

else:

fdmResult = account[0:4] + "." + account[5:9] + "." + account[10:15]

Share with friends   

Written by

The author did not add any Information to his profile yet

Comments 0

Leave a Reply