Survive multiple values from different rows using t_SurviveFields

Highlighted
One Star

Survive multiple values from different rows using t_SurviveFields

Hi Guys,

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?

Regards
Employee

Re: Survive multiple values from different rows using t_SurviveFields

Hi badduck

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.

See the attached pictures.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read