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
1 Like
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 
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 
1 Like
you mean to say to remove duplicates ?
I found some solution, no problem 
1 Like
Make sure you have “AddHeaders” checked in the read range activity.
can you please tell, the sol??