Looking for the development of an Excel workbook data profiling tool.
The workbook should be able to accept input files in XLS, XLSX, CSV, and pipe (|) delimited text formats.
The workbook will then perform basic statistical and structural analysis of the fields (aka columns) of the input file and produce a report describing the information:
file record count
file field count
most common value
most common value occurrence
The macro's code should be fully commented so that edits and updates can be made over time.
August 10, 2018
I am looking for a mix of experience and value