Icon

Audit SAP Fuzzy Name Matching

<p><strong>SAP Fuzzy Name Matching</strong></p><p>This workflow is useful to identify and reduce duplication of entries in master data files by detecting any entries that have slightly different spellings. The existence of such duplicates can result in incomplete management reporting and decision-making, and could be either unintentional or the result of fraud. In this specific example we are looking at SAP Vendor Master records but the workflow can be applied to a wide variety of data (e.g., employees, customers, vendors etc.)</p><p>To see an example of this workflow in action, click the Workflow Demonstration link under External Resources</p><p>This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com</p><p></p><p></p>

URL: Workflow Demonstration https://youtu.be/tDQQ7ysiipg
URL: www.dvwanalytics.com https://www.dvwanalytics.com/knime-connector-for-sap.html

Fuzzy Name Matching


This workflow is useful to identify and reduce duplication of entries in master data files by detecting any entries that have slightly different spellings. The existence of such duplicates can result in incomplete management reporting and decision-making, and could be either unintentional or the result of fraud. In this specific example we are looking at SAP Vendor Master records but the workflow can be applied to a wide variety of data (e.g., employees, customers, vendors etc.)

To see an example of this workflow in action, click the Workflow Demonstration link under External Resources

This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com

Data Extraction

Data Exploration

Data Validation

Identify Fuzzy Names

Dashboard & Report Generation

Apply different teststo validate data (numeric,strig, date&time,missing values, etc.)
Data Validation
Select the type of reportyou want to generate
Analysis Dashboard & Report
For numeric columns:it checks missing values andcomputes summary stats
Statistics of Dataset
Configure SAP Table Node to extract data from SAP
SAP Table
Select name fieldand view all identifiedfuzzy occurrences
Fuzzy Matching

Nodes

Extensions

Links