Lookup

Help
1

Hello,

I want to perform a comparison between two workbooks and if the value exists in both, check if other numbers are equal.

Say file 1 has a man named Steve and he owes $40
I need to check for Steve in file 2 and if he owes the same $40

How can this be done? Thanks

2

HI
lets say we have two datatables obtained on reading those two excel files named dt1 and dt2
–now use a FOR EACH ROW activity and pass the dt1 variable as input
–inside the loop use a LOOKUP DATATABLE ACTIVITY and mention the property as
input = row(“yourcolumnname”).ToString
datatable = dt2
lookup columnname = “columnname” from dt2
target columnname = “columnname” from dt2 whose value is going to be the output
Result = str_output //a string variable that will store the output from dt2 for corresponding column value in dt1

–next to this LOOKUP DATATABLE ACTIVITY use a IF Condition like this
row(“columnname from dt1”).ToString.Equals(str_output.ToString)
if true it will go to THEN part of IF condition or goes to ELSE

Cheers @sparkplug93

3

Name_Value.zip (29.8 KB)

I have created a workflow based on your requirements.

4

I’m having an issue with the lookup and target column

5

may i know what is the issue you were facing
@sparkplug93

6

I’m confused as to which table is used in what situations