Multiple lookups

abhide · May 15, 2021, 10:52am

I want to use multiple lookups if data matches in three columns then 4th column should be subtracted Please help

Shraddha_Gore · May 15, 2021, 12:45pm

Hi @abhide ,

Check this sample workflow & modify as per your requirement.

Workflow:
Compare_Columns.zip (3.2 KB)

copy_writes · May 15, 2021, 12:53pm

go through the below topic

regards
Chethan P

abhide · May 15, 2021, 4:22pm

Hi Chetan thanks for your input can you show me what’s inside the look up data table and also inside assign activities please.

abhide · May 15, 2021, 4:23pm

Hi Shraddha thanks for the inputs but i when i download the workflow it is showing errors. can you help me please

copy_writes · May 15, 2021, 4:38pm

I share the link of the topic you can go through it you will get the zip file of the project

If you get the solution please mark it as solved

Regards
Chethan P

abhide · May 15, 2021, 4:39pm

Ok let me look in to it thanks

abhide · May 15, 2021, 4:42pm

Should i install some packages i dont know why i am getting such error

copy_writes · May 15, 2021, 4:47pm

yes go to project in Bellow of activity panel you just update or repair the package.

abhide · May 15, 2021, 5:26pm

uipath_error
I still have one error any idea how to solve this

copy_writes · May 16, 2021, 2:34am

FormQuestion1.zip (11.7 KB)
I hope this is helps to you

If you get the Solution MARK IT AS SOLUTION

regards
Chethan P

abhide · May 16, 2021, 3:43am

I dont know why i am getting this error I have installed all the required packages suggested

copy_writes · May 16, 2021, 3:52am

Ok i will provide the screenshoot

copy_writes · May 16, 2021, 4:11am

bellow i show what is the inside of the Lookup data table

Hear number is where you want to add or target the column name

this is second LookUp data table

Hear in the below i use dt3 means third data table sheet no 3 ok and save it in opDT3
Hear am Using Column Index is o i target name ok
column index 1 is target number column

CInt(Row1(1))+CInt(OpDT2)+Cint(OpDT3)

make Shure the variable type

Hear am save total into row(1) why means i have to print in another sheet4 soo
row(1) is for each

last One is
Out side of the for each use write range

I hop you under stand the project

If you get the solution please mark it as solution and close this thread

Regards
Chethan P

abhide · May 16, 2021, 4:19am

Let me run this and get back to you. Thanks a lot for your timely feedback

copy_writes · May 16, 2021, 4:21am

Its ok no problem fell free if u get any dought ask

regards
happy automation

abhide · May 16, 2021, 5:54am

ss2

Hi chetan in the program you mentioned it looks only for bread, sausage in column A. but i want to see if it matches all three (column A,B,C) city item and material then only difference should happen