How to Re-group similar records grouped already
Posted: Mon Nov 21, 2011 12:37 pm
Hi All,
Do you know how we can regroup the records which is grouped already ?
I need to first group the records based on SSN/First Name/Middle Name/Last Name/DOB & assign GROUP_ID (which i did through sort stage-Key change column option & transformer stage variable).
Now, the next step is to regroup the already grouped records based on next set of conditions (like SSN Null/First Name null etc), but we should not loose the grouping already derived.
Can you pls shed some light on this.
Thanks,
Freddie
Do you know how we can regroup the records which is grouped already ?
I need to first group the records based on SSN/First Name/Middle Name/Last Name/DOB & assign GROUP_ID (which i did through sort stage-Key change column option & transformer stage variable).
Now, the next step is to regroup the already grouped records based on next set of conditions (like SSN Null/First Name null etc), but we should not loose the grouping already derived.
Can you pls shed some light on this.
Thanks,
Freddie