Read Range: A column named '20' already belongs to this DataTable

I have tried to check and uncheck the checkbox in read range. If I uncheck that in If condition it is giving another error that “Column ABC does not belongs to data table”.
Can someone help me on this?

1 Like

Hello @Sharmistha_Kundu,

Make sure the column name is exactly same in excel it should not contain white space and it’s case sensitive!

Cheers
@Sharmistha_Kundu

Tried that as well, even it was working before I have just changed in the end part. I have used write cell in place of write range.

A column named ‘20’ already belongs to this data table

Please check if you have any duplicate columns in your excel!

Cheers

That’s what you are getting Read Range error you have duplicate column please check

CompairMultipledata.zip (27.8 KB)
It is not having any duplicate values as well.

1 Like

Hello @Sharmistha_Kundu,

what are you actually trying this code??

1 Like

Hello @Sharmistha_Kundu,

It’s working fine for me made few changes on the code.

1 Like

Can you please tell me what changes you have made ?
Is that Column name Rate is coming on header ?

1 Like

Hello @Sharmistha_KunduCompairMultipledata.zip (22.9 KB)

When you run for the first time it’s working fine, When you are running again it’s throwing an error because you are using Write Range at the end and starting from cell Y so again it’s creating entire duplicate columns so it throwing an error

Better use Write Cell

Cheers
@Sharmistha_Kundu

1 Like

Thanks I will check that part :smile:

I am also trying to merge duplicate row and make it as single row using group by, if you have any idea can you please share that :innocent:

1 Like

you mean to say to remove duplicates ?

I found some solution, no problem :smiley:

1 Like

Make sure you have “AddHeaders” checked in the read range activity.
image