Mapping fields that have errors

[#1]

Hello, I work with a data base with a few errors in it and I wish to remap the errors to the correct ones.

I have entries that are setup as 'SO' and they should be 'S0', I have 6 in total to 'Map' How do I go about this?

paul.

[fosuzuki]

Hi paul,

you could create a mapping table:

mapEntries:

mapping load * inline [

     Before, After

     SO, S0

     SI, S1

     SA, S4

];

and then in your load statement:

LOAD ID,

     applymap('mapEntries', YourFieldName) AS YourFieldName

FROM XXX;

Hope this helps

Fernando