Yes, if you use "+" in your expression, then the numeric sum will be computed
if the fields areintegers and the catenation if they are strings; the former
will not yield the desired uniqueness.But now that I think about it some more,
even the latter will not, here's why: If the fields in onerecord are 'Hello'
and 'World' and in another record are "He" and "lloWorld", both will give
youthe same catenated value: 'HelloWorld' and will be considered duplicates.
If you can identify a character that is guaranteed to not occur in the string
fields, you can useit as a separator and that will give you the desired
uniqueness. For example, if "#" is such acharacter, then the 2 cases above will
give you distinct strings: "Hello#World" and "He#lloWorld"and there is no
problem.
Ram
On Thursday, October 26, 2017, 3:58:19 PM PDT, Vivek Bhide
<vivek.bh...@target.com> wrote:
Thanks Ram.. so are you saying that more than one integer fields in dedup key
will calculate the sum of the two fields where in terms of strings it will
concatenate them (because of + overloading)?
Regards
Vivek
--
Sent from: http://apache-apex-users-list.78494.x6.nabble.com/
