Question regarding business rules:

Question

How to write a business rule that solves following problem:

Here’s some of the business rules I was able to create:

1. If “Name” equals “XYZ corporation” then ACTION: is not valid
2. If “Country” equals “USA” then ACTION: change it to “United states”.

But what I am not able to figure out from the Web UI in the business rules of the MDS is to finding matching values, Here’s what I mean:

Here’s a sample table before we apply business rules:

Name	City	Validation status
Data Corporation	Dallas
Data Corporation	New york
XYZ Supermarket	Seattle
ABC Supermarket	Boston

Now what I am not able to find is: How to write a business rule that checks for matching values from the “Name” column and after running the rules. Something like:

For each value in Name column:

                If [value] matches* with [any other value in the Name column]

Then

                Flag the record as not valid

*For our needs, matches with could be implemented with “IS EQUAL TO” condition.

And after applying the rule, we get:

Name	City	Validation status
Data Corporation	Dallas	Failed
Data Corporation	New york	Failed
XYZ Supermarket	Seattle	Succeeded
ABC Supermarket	Boston	Succeeded

I read the topics listed under the business rules section from Books online (http://msdn.microsoft.com/en-us/library/ff487015.aspx
) but I was not able to find something about this problem. your help is appreciated!

Answer 1

I am not sure I understand your requirement completely, Are to trying to find whether duplicates exists in name column?