โ01-05-2021 12:49 AM
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
โ01-05-2021 08:37 AM
Hi @mohit,
You can read-in the excel file with duplicate columns if you have the un-checked the โContains headersโ in the next โExcel Parserโ snap
Then with a mapper, you can remove the duplicate column and introduce a row number (snap.in.totalCount) column at the same time, because in the next step youโd want to filter the first row that contains the real Headers, โฆ so ending up with something like this:
Example pipeline attached:
IM_remove_duplicate_columns_example_2021_01_05.slp (7.7 KB)
/Igor
โ01-06-2021 07:04 AM
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
โ01-06-2021 12:56 PM
Hi Mohit
Attaching a sample that should help you solve it. community_duplicate_columns_example_2021_01_06.slp (11.7 KB) sampleworkbook.xlsx (8.7 KB)