Data Manager - Advanced search in the view staged data doesn't have a filter for empty values

XMLWordPrintable

    • 17
    • 3

      Issue Summary

      The advanced search in the View Staging Data only has the options to filter for Null or Not Null attributes. There is no option to filter for empty or non-empty attributes.

      In the Analysis advanced search, we can use empty, not empty, null or empty, not null or empty. 

      Steps to Reproduce

      1. Create a job
      2. Run the job
      3. In the Cleanse and Import, select the related data source
      4. Click the ellipsis and then View Staged data
      5. In the advanced filter, there is no option for empty attributes.

      Expected Results

      Filter empty attributes

      Actual Results

      You can only filter null attributes. Doing so, empty attributes are still shown.

      Workaround

      In the job settings, add a transform function to "Replace with null" an empty column.

              Assignee:
              Unassigned
              Reporter:
              Diego Borba (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: