Hi All,
We are having an issue where we have customer number maintained as both with and without leading zeroes like as 123 and 00123.
If we run the matching strategy we get as None as it is considering those as different value.
Is there some way so that it neglects only the leading zeroes and not all the zeroes in it or is there some other way .
I cannot use only 0 in substitution as after transformation it considers 10234 and 12034 as same a
Please if anyone can need input in this.
Thanks and Regards
Nitin
Hello,
Define a assignment for customer number,
whose logic will be, if check the length and assign leading zero's accordingly.
for ex, 12, 123, 12345
so after the assignment it should be 0000000012, 0000000123, 0000012345.
and then run your strategy. You will get proper results.
Regards,
Abhishek
Add a comment