Forum Discussion
Hi @UrsVinny,
You can try using Mapper with Null-Safe access on,
And after this Mapper use another one that will filter null value from the root object.
Example Input:
Example Output:
Let me know if this helps you.
BR,
Aleksandar.
- stephenknilans8 years agoContributor
x==null (do if x is null)
x!=null (do if x is NOT null)BTW there are TWO types of null in snaplogic.
- The above, where the field exists and LITERALLY has a value of null
- 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.
- AdityaReja8 years agoNew Contributor III
i need to check for entire input stream not for one particular variable in $, like if the $ is null or not
- stephenknilans8 years agoContributor
There should always be some all important piece of data, like a key. You can reasonably assume the whole record is null if IT is. What are you trying to do?
I also use the router snap and check if a field exists using the .hasOwnProperty() function
- stephenknilans8 years agoContributor
I got stuck using what they suggested, but there are a few options. Still the point is that some fields simply aren’t created.
Related Content
- 3 years ago
- 8 years ago
- 4 years ago
- 8 years ago