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
How to Re-group similar records grouped already
Moderators: chulett, rschirm, roy
How is this any different from your other post on this topic? Other than being... shorter. ![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks for the reply Chulett & Ray. I felt my first post is too elaborate & confusing. So, rephrased to make it simple.
Ray, is there a way we can handle this scenario in DataStage ? As you said, we are planning to use Quality Stage for this requirement. Can you pls let me know what should be approach to arrive at the expected output using Quality Stage.
Thanks for the responses.
Ray, is there a way we can handle this scenario in DataStage ? As you said, we are planning to use Quality Stage for this requirement. Can you pls let me know what should be approach to arrive at the expected output using Quality Stage.
Thanks for the responses.