3 Replies Latest reply on Sep 13, 2016 8:56 AM by 2750537

    How to suppress 0 while importing SAP data in FDM using event script.

    2750537

      Hi,

       

      We want to  suppress records having 0 amount when it is being imported to FDM. I was trying to use event scripts but confused which one to use for said purpose.

      I saw one oracle document stating below code -

       

      delStmt = """

      DELETE FROM tdataseg_t

      WHERE loadid = ?

      AND amount = 0

      """

      params = [ fdmContext["LOADID"] ]

      delCount = fdmAPI.executeDML(delStmt, params, True)

       

      but this one does not get validated. Seems it is for FDMEE while we are using FDM Classic.

       

      Any help will be much appreciated.

       

      Regards,

      Sushil