From the Profiling perspective, you can better explore the quality of data in tables in delimited files through either:
Creating a simple table analysis through analyzing all columns in the table using patterns.
For more information, see Creating a column set analysis on a delimited file using patterns.
Comparing a set of columns and creating groups of similar records using blocking and matching keys and/or survivorship rules.
For more information, see Analyzing duplicates.