Forum Discussion

ravisangam's avatar
ravisangam
Occasional Contributor
9 years ago

Read data from Excel using DBTable variable. Actually the column names are having spaces and "."

Hi, I have added a dbTable variable to my project and provided information about my execl file and sheet.

The excel file is having data columns with spaces and duplicate columns have same name.

 

How can i solve this?

  • dmiscannon's avatar
    dmiscannon
    Frequent Contributor
    9 years ago

    The Excel column names must be unique for a DDT variable. You will have to ensure that each column in the Excel spreadsheet has a different name.