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?
you could create a mapping table:
mapping load * inline [
and then in your load statement:
applymap('mapEntries', YourFieldName) AS YourFieldName
Hope this helps
Retrieving data ...