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