Excel Source file and mapping to a target DB file

David Paras

• September 05, 2013 15:58

I am using an Excel Source file and mapping to a target a DB file(updating)

A column in the Excel sheet should be equal to a data base field for the mapping (update ) of the DB file to occur.

 

Here is an  example of what I am trying to do

 

 

Excel Sheet

Vendor#

AP Vendor Number

Additional fields

 

 

DB File

Vendor #

AP Vendor Number

Additional fields

 

 

I want to map AP Vendor number(Excel) to  AP vendor number(DB)…

But only IF Vendor #(Excel) = Vendor #(DB)

1

• 

  David Paras

  • September 05, 2013 15:59

  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 ]

  0

Post is closed for comments.