Forum Discussion

New Contributor

5 years ago

Parse Excel file with duplicate columns

Hi All, I have same column name multiple times in excel file. I want to parse all and load them into database but excel parser throws error of duplicate columns. Please suggest. Thanks

mohit

New Contributor

5 years ago

Hi @ igormicev
Thanks for the reply but I don’t want to remove the Duplicate columns. What I want to do is below 🙂
Lets say I have two duplicate columns Address, Address. So I want to take both the columns insert the data into database but with new name like Address and Address1. And I don’t want to do this manually by giving the name individually in mapper.

Can you suggest something.

Thanks
Mohit Yadav