Skip to Content
author's profile photo Former Member
Former Member

Matching issue in Data Manager

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2011 at 08:00 AM

    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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2011 at 08:56 AM

    Hi Abhishek,

    Thanks

    The problem is that this field is a part of Tuple and assignment cannot be written for Tuple.

    Is there any other way

    Regards

    Nitin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 07:34 AM

    Hi All,

    Thanks for providing your input.

    We are going to solve this issue by changing the value itself as a part of tuple update as mentioned in one of my other thread

    Thanks once again

    Regards

    Nitin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.