I don't think there's anything pre-build to calculate the max of a list of records. The max function exists in EEL but will take values as arguments, so not what you need.   You can try to use some simple code in the Expression node  //Pre-Expression  //Setting variables boolean isMaxVal; hidden integer prevMaxVal; isMaxVal= false; prevMaxVal=0; //Expression if `Frequency` >= prevMaxVal begin isMaxVal = true; prevMaxVal=`Frequency`; end else isMaxVal=false; This might require your data to be sorted though. The same logic could apply to the latest value.    Does this help? ... View more

Hi,   In Data Management Studio, there's a function/node called Clustering under the Entity Resolution group. You can use it to create groups (or clusters) of records that match according to your rules. You will need to set a value in the "Output Cluster ID field", which will the name of the new column created to identify your groups. Then, in the Conditions, you can add as many matching Conditions as you want. In your case, I believe you should have 3: Key1, Key2 and Key3.   You could have used your fields without concatenating them in the Conditions like: Condition 1 = FirstName AND LastName AND EmailID AND PhoneNumber AND AccountNumber OR Condition 2 =  FirstName AND LastName AND EmailID AND PhoneNumber OR  Condition 3 =  FirstName AND LastName AND EmailID. In the "More Options" button, the option "Condition matched field prefix" once checked will create new columns to tell you which condition matched.   There are also other capabilities like Matching that you could use, to do some fuzzy matching on your data. For example, in case you want to match people named "Jon Davis" and "John Davis". Take a look at the node called Matching and tell us if you have more questions.   Hope this helps, Audrey       ... View more