Error while using Excel Parser

[Marimuthu86]

Hi Team,
I’m facing below error when trying to read similar column names from same sheet but under different section. Could someone please assist?

Usecase2.slp (4.7 KB)

Thanks,
Muthu

[shankarrao2]

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439019/Excel+Parser

You can mention the columns like b,c so on. as mentioned in the image

[Marimuthu86]

Hi Shankar,
Even after changing column names, i’m still getting same error.
It looks like when we have two columns with same header text(name), the snap throws out error.
If there any solution to sort these kind of scenario? Or is this a limitation in tool?
Please suggest.

Thanks,
Muthu

[shankarrao2]

When you mention the columns names as a,b,c…so on, It will not look at header names so there will no conflict with column names.

This worked for me after duplicate column names also.

[Marimuthu86]

Hi Shankar,
Could you please share your pipeline if possible? If would be great for me to view and replicate for my data