Mapping fields that have errors

Tue, 09 Oct 2012 12:01:15 GMT

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.

Re: Mapping fields that have errors

fosuzuki — Tue, 09 Oct 2012 12:37:12 GMT

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