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.
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.