Compaire two datatable

[Pranali_Kadam]

Hi, need some help.
I have two datatable

DT1

DT2

I need two compare these two-table based on ref no and check no and output should be like these.

[lrtetala (Lakshman Reddy)]

Hi @Pranali_Kadam

Use Join Data Table activity

[Shiva_Nikhil]

Use Join datatable activity

you can try this with join Type as Full

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Pranali_Kadam ,
You can join data table
at wizard check amount in dt1 = dt2
regards,
LNV

[Pranali_Kadam]

Thanks for your replay.
I have already tried with Join but not getting expected output as the output I am expecting is-1) ref not matching 2) if ref matches then check for amount if amounts are same not then add those two rows with note in another dt.
Is there any other way?

[Shiva_Nikhil]

can you once check

its working with Join Datatable

if not let me know

[ppr (Peter Preuss)]

@Pranali_Kadam

but not getting expected output as the output I am expecting

the expected output is to produce / to examine after joining the data tables using the join data table result

Reference Num = Null, Data not present in dt1
Check No = Null, Data not present in dt2