F.A.Q.

Showing Column Names when Profiling Excel Files

Showing Column Names when Profiling Excel Files
  • Anonymous
  • 0 replies

Do you profile an Excel file and are you unable to see the column names? DQ Analyzer is not processing the column header and in the profiling results, you see the names of the columns as Field_0, Field_1, etc.

You can achieve the desired result by editing the metadata of the file you want to profile.

  1. Find the necessary file under the File Explorer window.
  2. Right-click on it and choose the Edit Metadata option.
  3. Specify the column you want it to start with. You should be able to see that the Name of the columns will change automatically. You can verify the column type, as well.
  4. Then you can profile the file.

0 replies

Be the first to reply!

Reply