Rearrange the records based on all matched numbers
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am
Rearrange the records based on all matched numbers
Hi,
I have recrds some thing like below
AGD U20081120AGDCPF Consolidated Unprocessed Payment Report AGD
Acc_No, CCY, Value_Date, Total, PROD
706155031,EUR,081124,1752.96,FTI
706155031,USD,081124,1752.96,FTI
38365029,SGD,081124,700,FTI
38365029,GBP,081124,381.88,FTI
706155078,EUR,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,USD,081124,1752.96,DDE
38365029,SGD,081124,700,DDE
706155078,EUR,081124,1752.96,DDE
And i want to arrange them in the way that all the records in order having same account numbers.
Example like below(Required output)
AGD U20081120AGDCPF Consolidated Unprocessed Payment Report AGD
Acc_No, CCY, Value_Date, Total, PROD
706155031,EUR,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,USD,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
38365029,SGD,081124,700,FTI
38365029,SGD,081124,700,DDE
38365029,GBP,081124,381.88,FTI
706155078,EUR,081124,1752.96,FTI
706155078,EUR,081124,1752.96,DDE
I tried with extracting group of records if the ( accno for PROD(FTI) = accno for PROD(DDE))
=F_ShuffleRec(EXTRACT(Record_FTI Group:Output,AcctNum:Record_FTI Group:Output=
AcctNum:Record_DDE Group:Output ),EXTRACT(Record_DDE Group:Output,AcctNum:Record_DDE Group:Output=AcctNum:Record_FTI Group:Output ))
I am getting some repeated records like below:
AGD U20081120AGDCPF Consolidated Unprocessed Payment Report AGD
Acc_No, CCY, Value_Date, Total, PROD
706155031,EUR,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,USD,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,EUR,081124,1752.96,FTI
706155031,USD,081124,1752.96,DDE
706155031,USD,081124,1752.96,FTI
706155031,USD,081124,1752.96,DDE
38365029,SGD,081124,700,FTI
38365029,SGD,081124,700,DDE
38365029,GBP,081124,381.88,FTI
38365029,SGD,081124,700,DDE
706155078,EUR,081124,1752.96,FTI
706155078,EUR,081124,1752.96,DDE
Can any one help on this,
Thanks,
Usha.
I have recrds some thing like below
AGD U20081120AGDCPF Consolidated Unprocessed Payment Report AGD
Acc_No, CCY, Value_Date, Total, PROD
706155031,EUR,081124,1752.96,FTI
706155031,USD,081124,1752.96,FTI
38365029,SGD,081124,700,FTI
38365029,GBP,081124,381.88,FTI
706155078,EUR,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,USD,081124,1752.96,DDE
38365029,SGD,081124,700,DDE
706155078,EUR,081124,1752.96,DDE
And i want to arrange them in the way that all the records in order having same account numbers.
Example like below(Required output)
AGD U20081120AGDCPF Consolidated Unprocessed Payment Report AGD
Acc_No, CCY, Value_Date, Total, PROD
706155031,EUR,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,USD,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
38365029,SGD,081124,700,FTI
38365029,SGD,081124,700,DDE
38365029,GBP,081124,381.88,FTI
706155078,EUR,081124,1752.96,FTI
706155078,EUR,081124,1752.96,DDE
I tried with extracting group of records if the ( accno for PROD(FTI) = accno for PROD(DDE))
=F_ShuffleRec(EXTRACT(Record_FTI Group:Output,AcctNum:Record_FTI Group:Output=
AcctNum:Record_DDE Group:Output ),EXTRACT(Record_DDE Group:Output,AcctNum:Record_DDE Group:Output=AcctNum:Record_FTI Group:Output ))
I am getting some repeated records like below:
AGD U20081120AGDCPF Consolidated Unprocessed Payment Report AGD
Acc_No, CCY, Value_Date, Total, PROD
706155031,EUR,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,USD,081124,1752.96,FTI
706155031,SGD,081124,1752.96,DDE
706155031,EUR,081124,1752.96,FTI
706155031,USD,081124,1752.96,DDE
706155031,USD,081124,1752.96,FTI
706155031,USD,081124,1752.96,DDE
38365029,SGD,081124,700,FTI
38365029,SGD,081124,700,DDE
38365029,GBP,081124,381.88,FTI
38365029,SGD,081124,700,DDE
706155078,EUR,081124,1752.96,FTI
706155078,EUR,081124,1752.96,DDE
Can any one help on this,
Thanks,
Usha.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am
U probably could but you really should ask Ray. And because you aren't aware of it, you probably don't have it so it will be somewhat... academic.ushasribandaru wrote:I am not aware of this QualityStage, can u help me to explain me in detail
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Search worked for me, were you not able to search for some reason?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Where from you are getting source data? From a table or a file?
If it is from a table, add a ORDER BY ACC NO in your SELECT SQL.
If it is from a sequential file, tell us your job design... i.e what is your source stage, target stage, processing stages in between etc.
Based on the forum index, i believe that your job is a server job. Please let us know if it is otherwise.
If it is from a table, add a ORDER BY ACC NO in your SELECT SQL.
If it is from a sequential file, tell us your job design... i.e what is your source stage, target stage, processing stages in between etc.
Based on the forum index, i believe that your job is a server job. Please let us know if it is otherwise.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am
[quote="kandyshandy"]Where from you are getting source data? From a table or a file?
If it is from a table, add a ORDER BY ACC NO in your SELECT SQL.
If it is from a sequential file, tell us your job design... i.e what is your source stage, target stage, processing stages in between etc.
Based on the forum index, i believe that your job is a server job. Please let us know if it is otherwise.[/quote]
Thank You
If it is from a table, add a ORDER BY ACC NO in your SELECT SQL.
If it is from a sequential file, tell us your job design... i.e what is your source stage, target stage, processing stages in between etc.
Based on the forum index, i believe that your job is a server job. Please let us know if it is otherwise.[/quote]
Thank You
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am
[quote="ray.wurlod"][url=http://www-01.ibm.com/software/data/inf ... litystage/]Search[/url] worked for me, were you not able to search for some reason? ...[/quote]
Thank you very much,I got it
Thank you very much,I got it