How to remove the duplicate Integer data in excel sheet

Help Community
#1

Hello,

i have excel data i want to apply filter on COl2 to remove the duplicate rows if Col2 is contains Integers not on Sting data duplicates rows.

Input
col1 col2
|as|6
|as|6
|as|8
|as|8
|as|A
|as|A
|as|B
|as|B
|as|C

O/p:

col1 col2
|as|6
|as|8
|as|A
|as|A
|as|B
|as|B
|as|C

help me

#2

Check this below workflow and change the filepath and sheet name in read range :+1: , @anilkumar.vegi
Uipath_RemoveDuplicateInteger.xaml (6.0 KB)
Hope this may help you :slight_smile:

#3

thanks you… i am checking

#4

Working fine…

thanks

i have one small point i missed it here sorry…

i want to check both col1 and col2 data is matching only i want to delete it… please help
some times col1 data is changing

col1 col2
|as|6
|as|6
|as|8
|ad|8
|as|A
|ad|A
|as|B
|as|B
|as|C

in this case i my o/p:

col1 col2
|as|6
|as|8
|ad|8
|as|A
|ad|A
|as|B
|as|B
|as|C

#5

Hi @anilkumar.vegi ,

Check this attachment Test.xaml (10.8 KB)

#6

Hi ,

while appending the string data to interger data it is duplicating …
2 times repeating same data.

help me

#7

Thanks for solution here foreach loop is using some times my data is more no of data …

#8

Share your sample data so that I can check from myside

#9

There is no other option without loop, for each can process any no. of data.

#10

Thanks ,

i/p:

RNO Pos Column3
R1402293 1 123
R1402293 1 123
R1402293 A 123
R1402293 A 123
R1402293 1 123
R1402294 1 123
R1402294 1 123
R1402294 2 123
R1402294 B 123
R1402294 B 123

O/P:

RNO Pos Column3
R1402293 1 123
R1402293 A 123
R1402293 A 123
R1402294 1 123
R1402294 2 123
R1402294 B 123
R1402294 B 123
#12

|R1402293|1|123|
|R1402294|1|123|

these 2 records only expect.

we have to eliminate repeated

#13

@anilkumar.vegi

Check the o/p here the workflow is working fine as your expectation
image

#14

perfect bro

#15

this is only expected