• TIBCO® Clarity User's Guide
  • Important Information
  • TIBCO Documentation and Support Services
  • Introduction to TIBCO Clarity
    • Terminology
  • Data Preparation Workflow
  • Subscribing to and Launching TIBCO Clarity
    • Registering an Account
    • Logging on to TIBCO Clarity
    • Subscribing to TIBCO Clarity
      • Upgrading Subscription
    • Launching TIBCO Clarity (Trial and Standard Subscribers)
    • Launching the Enterprise Edition of TIBCO Clarity (Premium Subscribers)
      • Configuration Parameters
      • Customizing the Configuration Parameters (Optional)
      • Windows Service Commands
      • Operating Windows Service (Optional)
      • Installing the Enterprise Edition
      • Logging on to the Enterprise Edition
        • Logging on as an Administrator
        • Logging on as a Standard User
  • User Interface
    • Dataset Summary Page
    • Project Data Page
  • Configuring Global Settings
    • Adding New Custom Data Types
      • Data Types and Constraints
    • Creating a Look-Up Table
    • Creating a Keyword List
    • Creating a Spotfire Connection
    • Creating a GeoAnalytics Connection
    • Creating a Google Maps Connection
    • Creating an ArcGIS Connection
    • Creating a Loqate Connection
    • Creating a Patterns Server Connection
    • Creating an Email Server Connection
    • Setting Facet Limit and Menu Configuration
    • Creating a Byteplant Usage for Phone Validation
    • Creating a Byteplant Usage for Email Validation
  • Creating Datasets and Projects
    • Creating a Dataset
      • Uploading Data
        • Uploading Data from a Local File
        • Uploading Data from the Web
        • Uploading Data from a Clipboard
        • Uploading Data from Cloud Storage
        • Uploading Data from a Database
        • Uploading Data from TIBCO MDM
        • Uploading Data from TIBCO Spotfire
        • Uploading Data from Salesforce
        • Uploading Data from Marketo
        • Uploading Data from TIBCO ActiveSpaces
          • Configuring a Connection to TIBCO ActiveSpaces
        • Uploading Data from OData
      • Parsing File
        • Parsing CSV/TSV Files
        • Parsing Line-based Text Files
        • Parsing Fixed-width Text Files
        • Parsing JSON Files
        • Parsing XML Files
        • Parsing TIBCO Spotfire Files
      • Mapping Data
      • Sampling Data
    • Creating a Project
  • Managing Datasets
    • Managing Projects
      • Launching TIBCO Clarity in View Mode
        • Enabling the View Mode Feature
        • Sharing the View Mode Page
    • Exporting a Dataset
    • Adding Source Data from Multiple Files
  • Manipulating a Column
    • Faceting Column Data
    • Searching Column Data
    • Editing Cells
      • Transforming Cells
      • Blanking and Filling Cells
      • Splitting and Merging Cells
      • Clustering Cells
    • Editing Columns
      • Splitting a Column
        • Splitting into Several Columns
        • Splitting Columns by Condition
        • Splitting and Reordering Columns
      • Adding a Column
        • Adding a Column Based on This Column
        • Adding a Column by Fetching URLs
      • Validating and Transforming the Contacts of a Column
        • Transforming the Phone Number Format of a Column
        • Validating the Phone Numbers of a Column
        • Validating the Email Addresses of a Column
      • Transforming the Date Format of a Column
    • Transposing Data
      • Transposing Cells across Columns into Rows
      • Transposing Columns by Key/Value
    • Sorting Data
    • General Refine Expression Language
    • Using GREL
  • Managing Project Data
    • Alternating between Rows and Records Modes
    • Faceting Project Data
    • Searching Project Data
    • Editing Rows
    • Editing Records
      • Aggregating Each Column of a Record
      • Aggregating Records with Conditions
    • Editing Columns
      • Merging Numeric Columns
    • Checking Dependency
  • Profiling Data
    • Performing Row Analysis
    • Performing Column Analysis
      • Column Analysis Report
  • Validating Data
  • Charting Data
    • Settings for Chart
    • Creating a Chart
  • Address Cleansing
    • Running Address Cleansing with TIBCO GeoAnalytics
    • Running Address Cleansing with Google Maps
    • Running Address Cleansing with ArcGIS
    • Running Address Cleansing with Loqate
    • Address Cleansing Results
    • Address Cleansing Limit
  • Batch Processing
    • Selecting the Batch Operations
    • Creating a Batch or Streaming Job
    • Batch Job Results
    • Streaming Job Results
  • Detecting Duplicates
    • Checking Duplicates
      • Managing External Tables
      • Managing Thesaurus Tables
    • Dedup Factors
    • Dedup Results
  • Managing OData Warehouse
    • Configuring OData Warehouse
    • Synchronizing Data to OData Warehouse
      • Synchronizing Data to a New Table
      • OData Primitive Types
      • Synchronizing Data to an Existing Table
    • Managing Data on OData Warehouse
    • Going to OData Warehouse
  • Exporting Project Data
    • Exporting Data to a File
      • Exporting Data by Table Exporter
      • Exporting Data by Template
    • Exporting Data to a Database
    • Exporting Data to TIBCO MDM
      • Uploading Data to TIBCO MDM Only
      • Uploading and Importing Data to TIBCO MDM
    • Exporting Data to TIBCO Spotfire
    • Exporting Data to Salesforce
    • Exporting Data to Marketo
    • Exporting Data to TIBCO ActiveSpaces
    • Exporting Data to Amazon S3
  • Clarity APIs
    • Clarity API Tutorial
• TIBCO® Clarity Examples
  • Important Information
  • TIBCO Documentation and Support Services
  • Sample Datasets Overview
  • Working with the Sample-customers Dataset
    • Creating a Dataset and a Project
      • Uploading Data from a Local File
      • Uploading Data from a Cloud Storage
      • Mapping Data
      • Creating a Project
        • Cloning a Project
    • Analyzing Data
      • Profiling Data
        • Performing Row Analysis
        • Performing Column Analysis
      • Faceting Data
        • Applying Pattern Facet to SSN
        • Applying Pattern Facet to ZIP
      • Checking Dependency
      • Charting Data
    • Validating Data
    • Transforming Data
      • Transforming Data Based on Pattern Facet Results
      • Transforming Date Formats
        • Removing Columns
        • Splitting a Column
      • Transforming Data Using a Look-up Table
        • Creating a Look-up Table
        • Using the Look-up Table
    • Cleansing Address
    • Deduplicating Data
  • Working with the Sample-patients Dataset
    • Analyzing Data
      • Profiling Data
        • Performing Row Analysis
        • Performing Column Analysis
      • Faceting Data
        • Faceting to Check Duplications
        • Faceting to Check Invalid Values
        • Faceting to Check Date Formats
        • Faceting to Check Data Integrity
      • Checking Dependency
      • Charting Data
        • Creating a Bar Chart to Check Duplicates
        • Creating a Bar Chart to Check Invalid Data
        • Creating a Pie Chart to Visualize Data Count
    • Validating Data
      • Validating Project Data
      • Profiling Validating Results
      • Exporting Validating Results
    • Transforming Data
      • Transforming Digit Numbers
      • Transforming Date Formats
    • Cleansing Data
      • Trimming White Spaces
      • Removing Empty Rows
      • Removing Invalid Data
      • Modifying Invalid Data
    • Delivering Data
      • Creating a Dataset and a Project
      • Cleansing Project Data
      • Exporting Project Data