Functional Dependencies

Functional dependencies are relationships that exist when the values in one column imply corresponding values in another column. When you create a worksheet, data profiling detects functional dependencies. Therefore, based on the values in column A, SAP Agile Data Preparation can predict the potential values in column B. This relatioinship means that rows with identical values in column A should have the same value in column B. Consequently, conflicts occur when instances of a specific value for column A appear with differing values in column B. Conflicting values commonly result from::

• Missing values

• Spelling errors

• Different abbreviations

For example, a specific ZIP code value implies a specific City value. Similarly, the same ZIP code value implies a specific State value. For the following sample address data, ZIP code 64108 implies Kansas City as well as the state of Missouri. In this example, the City value KC conflicts with the value KANSAS CITY.

SAP Agile Data Preparation provides two views for you to analyze functional dependencies and view conflicting values:

• Tree view

• Sunburst view