Actions options - 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
First publish date
2007
Last updated
2024-03-04
Published on
2024-03-04T22:52:13.486265
Option Description

Source type

Specifies the type of data to copy to the best of breed record. One of the following.

Field
Choose this option if you want to copy a value from a field to the best of breed record.
String
Choose this option if you want to copy a constant value to the best of breed record.

Source data

Specifies the data to copy to the best of breed record. If the source type is Field, select the field whose value you want to copy to the destination field. If the source type is String, specify a constant value to copy to the destination field.

Destination

Specifies the field in the best of breed record to which you want to copy the data specified in the Source data field.

Accumulate source data

If the data in the Source data field is numeric data, you can enable this option to combine the source data for all duplicate records and put the total value in the best of breed record.

For example, if there were three duplicate records in the group and they contained these values in the Deposits field:

100.00
                                20.00
                                5.00

Then all three values would be combined and the total value, 125.00, would be put in the best of breed record's Deposits field.