3 Replies Latest reply: Oct 9, 2018 9:08 AM by Jeshwanth Boragani RSS

    Scripting to compare data from two different sources

    Ankusha Dongre

      Hi All,

       

      I have a table named MAP1 : with fields CITY, STATE, COUNTRY_CODE.

      I have another table named INFO: with fields PICKUP_CITY, PICKUP_STATE,PICKUP_COUNTRY, DELIVERY_CITY, DELIVERY_STATE,DELIVERY_COUNTRY.


      So I want a script to Get proper State and Country Codes from MAP1 for PICKUP_CITY and DELIVERY_CITY in INFO table.