This macro pack has two macros.
The first macro (RecordsPerColumn) has two outputs:
The D (Data) output is the data input minus columns that are over X% null / empty. E.g. if the user says columns that are greater than 90% null /empty should be dropped, then those columns are dropped.
The next output is the M (Metadata) output. Which outputs
Column name, NonEmpty Records, Empty Records, Total Records, Percentage Null or Empty, User Percentage (what the user decided was percentage to be dropped), Type, and Description. The description field tells the user if the column was dropped or kept so that the user can filter for which ones did meet the appropriate threshold.
The second macro (MatchingColumns) also has two ouputs:
The D (Data) output is the data that was input into the macro minus columns that have the exact same data as other columns. If column A and column B are an exact match, then Column B will be dropped and Column A will be kept. There is no set order to which columns are kept and which ones are dropped, so be aware of this when using this macro.
The M (Metadata) output outputs the Column Name, Matches, Description (drop or keep), Type and Size.
