5 Replies Latest reply: Jun 21, 2016 10:42 AM by Troy Strachan RSS

    Normalize anomalies in data in LOAD

    Troy Strachan

      Hey everyone,

      I'm working with some legacy data that I am not allowed to alter within a DB.

      I'm trying to change things as simple as State/Province data entry errors. So I want ON instead of (ONT, Ontario, ONTARIO). Do you know of any way to change these values?

      Thanks in advance.