4 Replies Latest reply on Nov 30, 2021 11:59 AM by Shriharsha Manjunath

    Can we compare length of characters? Is there a not equal to? In MDM 10.4

    inuser556115 New Member

      Hi, I'm using Informatica Multi-Domain Master Data Management 10.4. In Advanced Query Builder - New Query, I'm trying to figure out how to compare length of characters.

       

      For example, where the longer or shorter phone number (more than 10, or less than 10) that doesn't have an OUS country code. USA has a country code of 1, 01, or +1.

       

      I'd like to create a script for the above example. I've tried a few things and even googled, but I'm not having much luck. Does anyone have any suggestions?

       

      Also, there is there way to search something not equal to?