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
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
- store them in DT1 and DT2 as you did earlier
- Use a for each row loop with DT1 as input
- use a look up datatable activity with these properties
LOOKUP.zip (14.0 KB)
Thats all buddy few steps isn’t it…
next time, try using the search function.
how can i compare 2 or more columns
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?
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:
Lookup Table with two possible columns matches can be found:
Output shows where matches have been found:
VLookups.zip (8.8 KB)
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
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.
thank you thats my doubt i got cleared i try with this!