D360 Analyze: How to remove /delete a column or row if all values are null

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.