Hi All,
I have a requirement in my project as below - I need to group the same customer records into one group by assigning GROUP_ID's.
See the example below,
SSN FIRST_NAME MIDDLE_NAME LAST_NAME DOB
1234 DAVE W JONES 09/12/1970
0 DAVE JONES 09/12/1970
2345 JIM C NICHOLS 08/08/1967
2345 JIM C NICHOLS NULL
4567 NULL F FARMS 12/12/1956
4567 KEEN F FARMS 12/12/1956
I am currently doing a Tight Grouping initially (through Sort Stage - Key Change column option/Soundex/Transformer Stage variables) using the above key fields. The output will look as follows,
SSN FIRST_NAME MIDDLE_NAME LAST_NAME DOB GROUP_ID
1234 DAVE W JONES 09/12/1970 G1
0 DAVE JONES 09/12/1970 G2
2345 JIM C NICHOLS 08/08/1967 G3
2345 JIM C NICHOLS NULL G4
4567 NULL F FARMS 12/12/1956 G5
4567 KEEN F FARMS 12/12/1956 G6
But the requirement is to group the similar records even if the above fields doesnt give a 100% match.
I am trying to re-group the already grouped records by changing the key fields in the 2nd job(Loose grouping), but i am loosing the already assigned grouping.
Can you pls help me resolve this scenario.
Thank You,
Freddie
Grouping Logic - How to Re-group similar records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: