Normalize and standardize fields using Gio™ AI Assistant - Precisely Data Integrity Suite

Clean and prepare data by making field values consistent and standardized across your dataset.

1. Select or create a pipeline (for example, Property_Policy_Holders).
2. In the pipeline canvas, click Gio™ AI Assistant to view its panel.
3. Select one of the following options to start the agent:
   • Normalize Fields: For making field values consistent (for example, fixing typos, standardizing codes).
   • Standardize Fields: For enforcing a single, correct format (for example, date formats).
   • Enrich Spatial Data: For adding spatial information (optional).
4. Type your request in the input box so the agent can analyze the dataset and suggest recommended steps.

   For example, type: "I want to standardize the Date, Country, state, addresses fields in this dataset."

5. Review the Recommended Steps flowchart and a detailed Steps and Reasoning table displayed by the agent.

   Each step includes a reasoning column that explains its purpose, as shown in the following examples:

   • Standardize Field: Converts country values to 3-letter ISO codes, flags unmapped values.
   • Standardize Date: Parses and outputs dates in a single format (YYYY-MM-DD), flags invalid or out-of-range values.
   • Verify Address: Standardizes and validates address fields for consistency and accuracy.
   • Custom Coding: Normalizes city names, classifies metro/non-metro, flags unmatched entries.
6. Click Add Steps to insert the recommended steps into your pipeline.
7. Optional: You can ask the agent to add further steps, such as: "Help me to add a step to ensure correctness of the data against business rules."

   The agent creates a new suggestion that includes the additional steps and the earlier recommendation (for example, additional standardization or validation).