Overview

This sample project shows how to use input and output steps to read data from a text file and write its contents to a new file.

Hello World

This sample project extends the overview sample by modifying the input data using some basic functions before writing it to a new file.

Lookup

This sample project demonstrates how to use external reference files to validate or enrich input data.

Build lookup file

This sample project shows how to create the reference files used in the Lookup sample.

Profiling

This sample project shows basic and advanced scenarios for creating a profile of a data file, which displays statistics, patterns, and other analyses of the data contained in the file.

Flow Control

This sample project shows the different types of filtering and joining steps, such as Filter, Condition, and Union and demonstrates the differences between them.

Transform

This sample project shows how you can clean and standardize data using rules.

Cleansing

This sample project demonstrates how to use pre-defined steps to parse and cleanse specific data fields.

Parsing

This sample project shows how to use name and title algorithms to separate name fields into different fields for title, first name and last name.

Match & Merge

This sample project demonstrates how to process a series of records and determine which records likely represent the same entity and assign the best value (“golden record”) for each field.

Measuring Data Quality

The Data Quality Indicator step calculates indicators for data quality and filters records not satisfying rules.

Using Databases

This sample project shows how to write data from a text file to a database.

SOA Services

Publishing DQC logic as a web service is simple. This tutorial demonstrates a SOA client written in Microsoft Excel VBA.