Survive multiple values from different rows using t_SurviveFields
I have the following rows of data of the same person. NAME UPDATETS ADDRESS AGE ALBERT CHUA 2/11/2011 1 2ND ST 22 ALBERT C 2/12/2011 2 4TH ST 23 C. ALBERT 2/13/2011 3 3RD ST 21 ALBERT CHUA 2/10/2011 3 3RD ST 23
After the survival process, I only want the following data. NAME UPDATETS ADDRESS AGE ALBERT CHUA 2/13/2011 3 3RD ST 23
The following rules to I'm trying to achieve: 1. NAME column is determine by the most frequent occurance 2. UPDATETS column is determine by the greatest value 3. ADDRESS column is determine by the UPDATETS column 4. AGE column is determine by the greatest value
How do I achieve 1 & 3 using a single t_SurviveFields process?
Re: Survive multiple values from different rows using t_SurviveFields
1. requires that you prepare a frequency table of the name occurrences. (a new component in 5.0 tRuleSurvivorship will handle this kind of requests more easily) 3. can just be done with the date field.