1 Reply Latest reply on Feb 13, 2010 12:30 PM by 694753

    check during import of data into FDQM


      We are uploading data into FDQM using flat files (*.csv)

      The requirement is that the import should stop if the sum total of amount column is NOT equal to zero

      We have a validation rule which throws this out as an error, but does not stop export to HFM, which is what we do not want

      Has anyone done this and can share this methodlogy please
        • 1. Re: check during import of data into FDQM
          actually there are number of ways
          first, you may stop whole process in very first step, before import into fdm, thus to save a tiime and dont import bad data.
          second, if your requirement regards checks on later steps, well you may just add exit command in export or load action in the adaptor itself
          next, you may write after validate event script, and set white fish if balance is not match