Compare 2 excel file columns

Help
, ,
1

i have to compare the same column in the 2 different excel files and if they are equal i have to make it as yes in that column otherwise no in that same excel as output

1 Like
2

Buddy may be this would help you… @priyankavivek
But i would like suggest one more option we have like lookup datatable activity, kindly find the below steps that be would be a add on and you can make use of it you want buddy

  1. store them in DT1 and DT2 as you did earlier
  2. Use a for each row loop with DT1 as input
  3. use a look up datatable activity with these properties
    LOOKUP.zip (14.0 KB)

Thats all buddy few steps isn’t it…
Cheers… @priyankavivek

2 Likes
3

next time, try using the search function.

1 Like
4

how can i compare 2 or more columns

1 Like
5

Buddy @priyankavivek
You can mention them in if condition buddy @priyankavivek
Cheers

6

can u please give me an example like i have to compare more than two columns in diffrent excels in if condition?dt1.Select(“NB = '” +item.Item(“NB”).ToString+“'”).FirstOrDefault() if i need to compare 2nd column where i should add my column name?

7

Using lookup datatable activity, look up your data on column1. IF there is no match, THEN lookup on column2. IF there is no match, ignore.

This example is trying to find IDs of employees from two possible columns. The output tells you in which column they have been found, or if no match was found.

Table with the output column we want to populate:
image

Lookup Table with two possible columns matches can be found:
image

Output shows where matches have been found:
image

Workflow:
VLookups.zip (8.8 KB)

8

here you have compared two colums like id and service id is it possible to make to compare more than two columns?please help me

9

If you want to cycle through a second column in your source datatable and compare against two columns in the lookup table, simply duplicate the For Each activity in the workflow I provided and update the Lookup Value.

image
image510Ă—675 21.6 KB

Could become

image
image519Ă—669 21.9 KB

2 Likes
10

thank you thats my doubt i got cleared i try with this!

11

how we can apply vlookup for more than 4 Columns in two different excel by considering only one column from one Excel? Please give solution.

12

Hi
Welcome to uipath community
In that case we need to use vb script or formula and lookup datatable activity can take only two datatable as input
To use vb script we can keep that code in INVOKE VBA or to use formula with WRITE CELL activity inside a loop

Cheers @Priyanka_Sorate

13

@Priyanka_Sorate
Can you Just Open a new Post with some Details and Sample Data. So WE can Help you on working Out a solution. LINQ maybe in Combination with General uipath activities would be the start for