Creating a Custom Match Rule as a JSON Object - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
Overview
Reference
Tips
How Do I
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265
Match rules can be configured and passed at runtime if they are exposed as dataflow options. This enables you to share match rules across machines and override existing match rules with JSON-formatted match rule strings. You can also set stage options when calling the job through a process flow or through the job executor command-line tool.

You can find schemas for MatchRule and MatchInfo in the following folder:

<Spectrum Location>\server\modules\jsonSchemas\matcher.
  1. Save and expose the dataflow that contains the match rule.
  2. Open the dataflow that uses the match rule.
  3. Go to Edit > Dataflow Options.
  4. In the Map dataflow options to stages table, click the matching stage that uses the match rule and check the Custom Match Rule box.
  5. Optional: Change the name of the match rule in the Option label field from "Custom Match Rule" to the name you prefer.
  6. Click OK twice.