USE CASE: I need a node, or some method for deleting a column if all values are null, for example I have column1, column2, column3 and I want to remove column 1 automatically if all values are null. I also want a tool that will remove a row of data if all the values are null.
SOLUTION:
Method 1: Use the attached nodes; Remove Null Records and Remove Null Columns. The attached data flow called Demo_Remove Nulls demonstrates how the nodes should be used. The Create Data nodes have a NULL record and column respectively, and the Remove Null Columns and Remove Null Record nodes demonstrate how the nulls are removed.
Method 2: Alternatively, also attached is a composite node (named Complete_Cases_v0.5.lna) that scans records to check if the all fields, or selected fields, contain nulls. If all the (selected) fields are non-Null (complete) the record is output on the first pin else the record is output on the second pin. It uses the include fields/ exclude fields paradigm with all fields scanned by default. It maintains the field types
Comments
0 comments
Please sign in to leave a comment.