8 Replies Latest reply: Jan 26, 2017 11:28 AM by Matthew Davies RSS

    Translate a file into a mapping load

    Matthew Davies

      Hi all,

       

      Have a problem, which is causing an issue.

       

      I want to load in a table which has lots of values. These codes will translate to a text field, that I want to apply in bulk.

       

      Example table:

      Mapping TableRaw codeNew Value
      CountryaUK
      CountrybUSA
      CountrycIRE
      Car Make1Fiat
      Car Make2Ford
      Car Make3Ferrari

       

      My aim is to turn these into two (and will be many many more) mapping tables to apply map over the field shown in mapping table.

       

      Example:

       

      [Mapping Table_Map]:

      Mapping load

      [Raw code]

      [New Value]

      Resident File;

       

      IS this possible?

       

      I have tried a few ways and with no luck. Can someone please help me??

       

      Any help will be massively appreciated.

       

      Matt