Name: Remove Records with All Property Values Null

Author: Andrei Caracoti

Version: 2.0

Created: 9/2003

Modified: 7/2007 – Components upgraded, and help text revised/added.

Purpose: To remove all data records that have null values for all properties. Please note that in Pipeline Pilot, the concept of a null value is in fact equivalent to the value being the empty string. In other words, a property is defined for a record, but the value is the empty string. The filter works by looping through all the properties on each record, and identifying records for which all the data property values are the empty string. Those records are sent out the fail port of the filter.

Requirements: Pipeline Pilot 6.1.1

O/S: PP Server Windows and Linux, PP Client Windows

Limitations: None

Keyword(s): pilotscript null empty property value record

Contents: Remove Records with All Property Values Null.xml, TestData7_07.csv (test data file)

Installation: Drag the component into the Pipeline Pilot client workspace and use in your protocols, or drag it and drop it on one of the Pipeline Pilot client explorer tabs to import it directly in the protocol database. You can test with the included csv file.