How to read Duplicate Column Names in Excel

[Aswini (Aswini Pula)]

Hi All,

Iam trying to read an Excel in which some duplicate column names exists.So when im using read range activity bot is throwing error saying like Column already belongs to the table.Is there any way to avoid the issue.

The highlted columns in yellow has same column names

[Yazan_Otaibi]

hi @Aswini
you cannot read table with duplicate coulmn name
you have to change the duplicate or remove it before reading the table

[Yoichi]

Hi,

The following post might help you.

How to ignore duplicate column names

Hi, I’ll attach simple sample as the following. Hope this helps you. Sample20201209_2.zip (9.1 KB) Regards,

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@Aswini

Find the “AddHeaders” property and set it to False . This tells the “Read Range” activity not to use the first row as column headers.