12.4.1 Create a Data Quality Errors based Data Adjustment

To create a data adjustment for the action type Data Adjustments - Data Quality Errors, follow these steps:

1. From the Issues & Actions page, under an action created, click View More.
2. On the Data Adjustment page, click Create.

   The Adjustments Rule Details window is displayed.

3. In the Adjustment Rule Details window, enter values in the Name and Description fields.

   Figure 12-6 Issues & Actions

   
   

   

   
   
4. Select the Assignment Type as either User Input or Rule Driven.
5. For User Input: The Select Entity and Select DQ are auto-populated. However, you have an option to select a different DQ if it has multiple DQs.
   1. Click Next.
   2. Select Add Attribute.
   3. In the Add Attribute window, in the Line Item, Target Attribute drop-downs, select the required values and then click OK.
   4. Click Next, and then click Save.
   5. In the Export window, in the MIS Date section, select a date for which the data is available, and then click Export.
   6. Save the Excel file to your system.
   7. Enter values in the required rows and then save the Excel.
   8. In the Manual Data section, in the ID column, select the required ID and then click Import.
   9. In the Import window, attach the Excel that you added data to, and then click Upload.
   10. Click Import.
   11. Click Submit if you want to send the Data Adjustment for approval or click Save.
6. For Rule Driven:
   1. To go to the next section, click Next or click Dataset.
   2. In the Select DQ dropdown box, select the required Data Quality value.

      This Data Adjustment is being created for this failed Data Quality.

   3. Click Next.
   4. Click Add Expression.
   5. Select a value from the drop-down box for Column.

      Note:

      You can ignore the Lookup section.
   6. Enter values in the following fields:

      Table 12-3 Add Expression Fields

      Field	Description
      String	Select a value from the drop-down box.
      Date and Time	Select a value from the drop-down box.
      Aggregate	Select a value from the drop-down box.
      Others	Select a value from the drop-down box.
      Mathematical	Select a value from the drop-down box.
      Concatenation	Select a value from the drop-down box.
      Mathematical operators	Select a value from the drop-down box.
      Others	Select a value from the drop-down box.
      Comparison	Select a value from the drop-down box.
      Logical Operators	Select a value from the drop-down box.
      Expression	Enter an expression.

   7. Click OK and click Next.
   8. In the Review and Save section, click Save.

The Data Adjustment for the action is created.