View previous topic :: View next topic
|
Author |
Message |
ajaybshukla
New User
Joined: 09 Sep 2008 Posts: 39 Location: india
|
|
|
|
Hi All,
Need Help!!!!
I have one file which is sorted flat file but in that file there are multiple records for the same say acct number eg
111111 ghkjk 000 ......
111111 ghkjk 012 ......
111111 ghkjk 012 ......
Now i want to select last record only out of these multiple instance of one record.
Please help me out to resolve this issue.
Thanks... |
|
Back to top |
|
|
maheshvamsi
New User
Joined: 22 Mar 2008 Posts: 39 Location: bangalore
|
|
Back to top |
|
|
ajaybshukla
New User
Joined: 09 Sep 2008 Posts: 39 Location: india
|
|
|
|
Hey its working...thank you very much |
|
Back to top |
|
|
r2k1984
New User
Joined: 21 Jun 2005 Posts: 69 Location: chennai
|
|
|
|
sort the record in descending order so that the last record comes first and put sum fields = none
it should work |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If the file is already in the needed sequence and the last record of some group is needed, sorting descending will not necessarily work.
The good news is that there is a working solution. . . |
|
Back to top |
|
|
|