Forum Discussion

AdityaReja's avatar
AdityaReja
New Contributor III
8 years ago

Check Incoming data is null

I’m getting data out of LDAP and i nees to route it to two different mappers depending upon whether the incoming data is null or not. But i’m unable to do this… any solution?

8 Replies

    • stephenknilans's avatar
      stephenknilans
      Contributor

      x==null (do if x is null)
      x!=null (do if x is NOT null)

      BTW there are TWO types of null in snaplogic.

      1. The above, where the field exists and LITERALLY has a value of null
      2. The all too common case of a field that hasn’t be defined because no row joined on an outer condition, or it wasn’t read, etc…

      What I spoke of earlier is for the 2nd case I listed above
      For case number 2, it would be

      !(‘x’ in $)
      (‘x’ in $)

      So remember, in some cases a field will not be created for a field that does not have a value and, in those cases, you have to check if the field exists.

      • AdityaReja's avatar
        AdityaReja
        New Contributor III

        i need to check for entire input stream not for one particular variable in $, like if the $ is null or not

    • nisars's avatar
      nisars
      New Contributor III

      I also use the router snap and check if a field exists using the .hasOwnProperty() function

      • stephenknilans's avatar
        stephenknilans
        Contributor

        I got stuck using what they suggested, but there are a few options. Still the point is that some fields simply aren’t created.