#Sqlpro set attribute show value how to
#Sqlpro set attribute show value update

Picked Attribute.Attributename is OtherAttributename and Other Attribute is a AttributeSourceInfoVO Other Attribute = AttributeSourceInfoVO and IF picked attribute is a AttributeSourceInfoVO

Values page with the IF and THEN rules condition values provided in Populate the Define Survivorship Rules: Select Attribute

#Sqlpro set attribute show value update

Information indicates that it has the earliest source update date.įrom the record with the ID 3 is selected as master because the source The following table contains information for sourceįrom the record with ID 1 is selected as master because the source

The following table contains information for party Is a use case for a set attribute rule to select the values with theĮarliest update date as surviving attribute values: This rule has a single condition to set all the survivingĪttribute values based on the earliest update date. How You Set the Values with the Earliest Update Incorporated Year as the Surviving Attribute Values Source Confidence Level as the Surviving Attribute Value for D-U-N-S Update Date as the Surviving Attribute Values Worked examples that show different ways of manually setting masterĪttribute values in the Define Survivorship Rules: Select Attribute The following sections of this topic contain three (or person) attribute: Use this rule to select the attribute values Values with the highest source confidence level. Wins for Organization (or Person): Use this rule to select the attribute You also have the option of using one of the following The criteria that you define in this page determine the feature Value page, you specify criteria for selecting the master attribute In the Define Survivorship Rules: Select Attribute Use the predefined set attribute rules, don't select any attributes.ĭefine Survivorship Rules: Select Attribute Value page. Template to select the surviving value based on the confidence inĪttributes to pre-populate the rules template. With the highest or lowest value such as a party number, or salary, ForĮxample, you need an Attribute Based template to pick an attribute Surviving value based on the characteristic of the attributes. Select the Attribute Based template to select the Select the master value for a specific attributeīased on specified master selection criteria. In the following table on the Create Survivorship Rule page. Tip: You can select attributes from the available attributes To create Set Attribute Value rules, you perform In this case, setAttribute function creates The THEN clause determines the output object that The date when the attribute was last updated. The source confidence level assigned to the source The source system from where the attribute is updated. Information VO to create a set attribute value rule. The following table lists the attributes in the source System and given a Source Confidence score on a scale of 1 to 100. You must map each attribute to its source It in the Define Source Systems Confidence page of the Manage Source

If you're creating rules that use the Source information VO, you define Information about all attributes for each record in the database. In a set attribute value rule, the inputs are the party The input to the survivorship rule is given in the Which attribute value should come from which record. Set attribute value rules are used in party merge to determine You can determine survivorship at the attribute level using the set attribute value

#Sqlpro set attribute show value how to

This example demonstrates how to create a survivorship rule of the type Set Attribute