I have two duplicate columns in a csv file and I wanted to calculate percentage as they are having duplicate columns

I have two duplicate columns in a csv file and I wanted to calculate percentage as they are having duplicate columns. When I am using Read CSV activity its getting error. Any suggestions would be helpful

Hi @Mohammed_Nawazuddin
welcome to forum
the error is due to duplicate columns,
to avoid that , you can try this way

Read csv file with Has Headers option unchecked. Then after reading it , remove the 1 row (which is header itself) and then after that use column index instead of column name to get each column details

Regards,
Nived N

It sound helpful.Can you suggest me how to remove the header column

Hi @Mohammed_Nawazuddin

This is way of deleting the header

@Mohammed_Nawazuddin

Welcome to forums

Check below for your reference

In Read CSV remove the check box Has Headers

Now if you want to perform any actions you can use Index of the columns