View previous topic :: View next topic
|
Author |
Message |
Hemamalini Vasudevan
New User
Joined: 21 Sep 2006 Posts: 5
|
|
|
|
When using SUM FIELDS=(none) OR (Some field from the layout),
the duplicate records will get eliminated. Which record will get eliminated the first record or the second record found (as both are same ). I tried testing and found both the scenario happening. If i want to retain the first record and eliminate the second what exactly to be done. |
|
Back to top |
|
|
vicky10001 Warnings : 1 Active User
Joined: 13 Jul 2005 Posts: 136
|
|
|
|
When used in conjunction with SUM, EQUALS indicates which of the equal-keyed records will be preserved, containing the sum: the record occurring first in SORTIN (for a sort), or drawn from the SORTINnn data set with the lowest nn number (for a merge) will contain the totaled fields. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
With EQUALS in effect, the first record for each set of duplicates is kept. With NOEQUALS in effect, any record of each set of duplicates can be kept.
Note that with the SELECT operator of DFSORT's ICETOOL, you can choose to have the FIRST or LAST record kept. |
|
Back to top |
|
|
|