Skip to main content
F.A.Q.

Showing Column Names when Profiling Excel Files

Showing Column Names when Profiling Excel Files

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.
Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings