Filter missing data or empty values using the Null-safe access option

This example pipeline demonstrates how to filter data with missing data or empty values using the Null-safe access checkbox.



Download this Pipeline

  1. Configure the JSON Generator Snap with the folowing data. Each record has location and salary except ID102, which does not have the location.


  2. Configure the Filter expression as $location=="Hyderabad" || $salary>=20000 which means the Snap should filter and display the records in the output that has the location as Hyderabad OR the salary at least INR 20000. Select the Null-safe access checkbox—the Snap then finds any missing data while accessing the source path ( such as record#102, which does not have a location); the Snap considers the field null, a valid filter criteria.


  3. Validate the pipeline, the Filter Snap return the output as follows:


To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.