3 Replies Latest reply on Dec 15, 2016 11:53 PM by 1008730

    FDMEE mapping script question

    1008730

      In FDMEE I have the following mapping script.

       

       

      sTargAmt=fdmRow.getString("AMOUNTX")

       

      if sTargAmt < 0:
           fdmResult = "24000"

       

       

       

      Now in my record I have a negative number, so the mapping should take place. However, it does not as if it does not recognize the negative amount.

       

      The log says:

      2016-12-13 14:19:37,568 INFO  [AIF]: Data Rows Updated by Location Mapping 'wx178' (LIKE): 0

      2016-12-13 14:19:37,568 WARN  [AIF]: Data rows targeted but not updated by the script: 2

       

      When I change the script to the following. The mapping will work (record amount is still negative)

       

      sTargAmt=fdmRow.getString("AMOUNTX")

       

      if sTargAmt >= 0:
           fdmResult = "24000"

       

       

      So why does it not recognize negative amount and suggestion to try? Thanks a bunch!