How to check 3 coloums in 3 datatables

[Tharusha_Fernando (Fernando ✔️)]

i have 3 data tables with same column call “code”
need to extract and write to a new dt
if that column “code” data similar at least common 3 out of 2 datatables
any ideas

[NIVED_NAMBIAR (NIVED N)]

Hi @Tharusha_Fernando can u show the input and output format u need so that we can help

[Tharusha_Fernando (Fernando ✔️)]

hi @NIVED_NAMBIAR plz find the excel sheet below
dt1.xlsx (8.8 KB) dt2.xlsx (8.8 KB) dt3.xlsx (8.5 KB) FInalbook.xlsx (9.2 KB)

[prasath17 (Guru)]

@Tharusha_Fernando - Is this the same you explained in the below post?

How to do a Complicated VLOOKUP

Hi team [Capture] i have a small complicated vlookup i have 4 datatables DT1 "code" coloum should compare with DT2 “code” coloum data if the code dt1 & dt2 “code” column data equal need to send to DT4 as Reconciled Challenge some times in Dt1 Code column has lager values**(green)** in that time i should compare the dt 3 with “code” 1 Column (green color) & dt2 that found code if any of the records cannot found it should send to unreconciled sheet Any Activity to archive this dt1.x…

[Tharusha_Fernando (Fernando ✔️)]

yes @prasath17 it is

i found that we can use join data tables in this
and use inner to and equal to match columns and it worked