Identify the duplicate

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.
image
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

we can get that with column index right
Cheers @balkishan

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.
image

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.
image
So I have to store/write these duplicate value in excel.
image

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.

Have you checked this @balkishan?

Excel Read Rangee