Profiling

  • DEFINITION: Data Types

    When you assign a data type to a column, Trifacta validates the records in that column against the data type, and updates the column’s Data Quality Bar and Values Histogram.You can assign any of the following data types to columns in Trifacta Wrangler:StringIntegerDecimalBooleanMapArrayIP AddressURLHTTP CodeDate/TimeSocial Security NumberPhone NumberEmail AddressCredit CardGenderZip CodeAddit…

  • FAQ: Profiling Your Results

    You can view a profile of your results files from the Results Summary page. This article provides details about the elements that you can use on the Results Summary page to profile and understand the contents of your results file.Summary information: The upper section of the Results Summary page provides summary information about the results file that you have generated. This section contains th…

  • HOW TO: View Mismatched Data

    1. Navigate to the column in your dataset that contains mismatched values.2. Click on the red section of the data quality bar for the column, as shown in the following image: Trifacta highlights mismatched rows of data in the Transformer Grid.3. You can limit the visible data to only mismatched rows by clicking on the “Transformed” filter at the top of the Transformer Grid: 4. After appl…

  • HOW TO: View Blank Data

    1. Navigate to the column in your dataset that contains blank values.2. Click on the grey section of the data quality bar for the column, as shown in the following image: Trifacta highlights blank rows of data in the Transformer Grid: 3. You can limit the visible data to only include blank rows in the selected column by clicking on the “Transformed” filter at the top of the Transformer …

  • HOW TO: View the Distribution of Data in a Column

    You can view the distribution of data values for a column in three places.1. In the histograms at the top of the column in the Transformer Grid: 2. In the Column Details profile view: 3. In the final output from the Job Results window presented at the end of a job execution: Note: Only the Job Results window shows data distributions across the complete dataset. The column histograms and Colu…

  • VIDEO: Finding Mismatched Values

    In this video, you'll learn how to use Trifacta to find mismatched values types within your columns.See Also:HOW TO: View Mismatched Datakeywords: mismatched data, profiling, types…