I have a excel and I put some duplicate columns, But when I read it thrown me and error message but I want to capture these value is it possible. I want to store these duplicate values somewhere.
here name is duplicate I want to store this in a variable, Likewise, all duplicate value or I can write these duplicates values in excel.
@Palaniyappan @HareeshMR @aksh1yadav
2 Likes
fine
in that case
use read range activity and mention the range to begin from second row like “A2” and uncheck the property ADD HEADERS
Cheers @balkishan
2 Likes
Then how do I find which is duplicate, basically I want write all duplicate headers if exist in the file.
1 Like
How bro.
see suppose we have 20 columns in the excel.
we have to read the columns first to enter the data to the system right, without read the column how we’ll feed the data right me if I am wrong!
second if have two duplicate columns name in the excel I have to identify and send email with the duplicate columns name. Hope you understand bro.
@chenderson see this bro
see here are two duplicate column name, First Name and second Location. how can we identify these two duplicate columns names.
Good morning Balkishan,
Are you able to use a read range on the headers ONLY (so all of row 1 for example) and then get a count of how many times each values appears in the result?
Hi Good Morning Chenderson,
since I am reading this excel file and it holds two duplicate headers values 1st Name and 2nd Location, but while reading it shows only one which is Name right, and we have two duplicate values Name & Location.
So I have to store/write these duplicate value in excel.
Note. this are exception files bcz usually I have to read the headers of the files to feed the data I can uncheck the AddHeader, if I don’t have any duplication in the data then I have to proceed further.
Yoichi
Anil_G
sai_gupta
Dilli_Reddy
Vinit_Kawle
Vinit_Mhatre
postwick
AutomationX_by_Kiran
Parvathy
Shiva_Nikhil