-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Assets - Data Manager - Cleanse & Import
-
None
-
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
- Create a job
- Run the job
- In the Cleanse and Import, select the related data source
- Click the ellipsis and then View Staged data
- 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.