Data Analysis

Using this facility will analyse the current data and provide a web report with a column by column breakdown.

One feature of the report is to show a list of the distinct values in each column. This can be overkill for some columns and Maximum Distinct Count allows you to set the largest amount of distinct values you wish to see per column. If it is exceeded then the distinct list is ignored altogether.

Identify unique columns will determine which columns contain completely unique values. This process can add considerable time and memory intensive.

Assume columns with leading zeros are text is used to avoid misidentifying data like phone numbers as pure numeric.

Skip analysis of first row does exactly what it says. Often you might load a text file including the header row as part of the data, the problem is it will be included in the analysis report. Ticking this will simply ignore the first row all together.