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]
