Exercise (optional): Validate and Transform data in a newly imported table

Steps:

  1. Bring a new table PurchaseOrderDetail from the ODX.
  2. Preview table to examine data rows and fields
  3. There is a field named RejectedQty (type decimal) on PurchaseOrderDetail table. You need to change all values from positive to negative in this field. How can you accomplish this task with minimal effort?


Hint: Review the User Guide topic Selecting, Validating and Transforming Data

Next