Skip to main content

Excel Source file and mapping to a target DB file


1 comment

  • David Paras

    We have looked into your scenario and this can achieved by using a DB Query inside the data mapper. Use a DB Query in which select the count if the vendor of source matches the vendor of database. For Example:

    DBQuery {select count(*) from tablename where vendor = $Input_Excel_Schema/Root/Record/vendor,$coninfo1 ,'false' }

    Then you can use this DBQuery in the IFF Condition to map the value of AP Vendor Number, if the count of DB query is not equal to zero then map the AP Vendor number else empty.

    IFF CONDITION{$var1 !=0} VALUE=[$Input_Excel_Schema/Root/Record/AP Vendor Number ]

Post is closed for comments.