How to ignore duplicate column names

Help
,
2

Hi,

Unfortunately, there is no way to ignore duplicated column name in ReadRange Activity. There are some workarounds as the following.

  1. Uncheck AddHeaders property then read range without header area.
    We need to use column index number instead of column name.

  2. Read range with AddHeaders property unchecked.
    Then, read first row and set each value as column name. if there are duplicated column name, change its name like “name-1”, “name-2”.
    Finally, remove the first row.

Regards,