Compare two text file

Learning Initatives Automation Starter
1

compare 1 text file data and that other 2 text file data e.g data means
one and two text file compare and how to task performing

text file how to action task performance last sending text file 3

e.g two compare text file and two for each used my intention and how to solve this task

2

Hi @nikhil.patil

Look on the link

Regards
Gokul

3

Duplicate : https://forum.uipath.com/t/compare-to-excel-data-table/468000/3

4 
         |  parameter to be filed |       Description

Type A | 2345 | Nikhil
Type A | 1256 | Rahul
Type A | | vinay
Type B | 3451 | Ram
Type B | 3456 | kunal
this my first excel

code | Address | Description | mobile_Number
0987 | ssd nagar | Akshay | 1234567789
2345 | Mukti dhaam | Nikhil | 1234567789
1256 | veerbhadra | Rahul | 1234567789
3451 | pawan nagar | Ram | 1234567789
3456 | mukai nagar | kunal | 1234567789

This my second excel

if column type A has code then delete that code row from secod excel ex2345 delete that row from second excel if Type A code not available then goto next line

5

You should use a join datatable activity for this

6

Hey @nikhil.patil,

Use dt2Output=dt2.AsEnumerable().Where(Function(row) dt1.AsEnumerable().Any(Function(x) x(“NAME”).ToString=row(“NAME”).ToString)).CopyToDatatable to get the matching records from that two datatable and store the output in a third datatable object dt2Output.

Use dt2=dt2.AsEnumerable().Where(Function(row) NOT dt2Output.AsEnumerable().Any(Function(x) x(“NAME”).ToString=row(“NAME”).ToString)).CopyToDatatable

Thanks,
Sanjit

7

Duplicate : Compare two text file

8

I merged the posts into one topic.

9

sample.xlsx (8.5 KB)
sample1.xlsx (8.5 KB)

check Type A in Sample.xlsx Excel if it has Parameters to be filed value available then delete that number row from second sample1.xlsx

10

Hey @nikhil.patil,

PFA the file for your reference.
DataTableManipulation.xaml (15.3 KB)

Thanks,
Sanjit