Hello @Rahul_Unnikrishnan @Gokul_Jayakumar @Mukesh_Kala @Yoichi @RAKESH_KUMAR_BEHERA
I think my question was conveyed in a wrong way… Let me explain it clearly.
I have two Datatables… Dt_1 and Dt_2 as shown below.
Datatable - 1 (Dt_1)
| Invoice No | Item Code | Price |
|---|---|---|
| 60003 | 50052 | 0.98 |
| 60003 | 50123 | 0.92 |
| 60003 | 70026 | 0.85 |
| 60003 | 50416 | 0.75 |
| 61086 | RS-50557 | 0.96 |
| 60021 | RS-50181 | 0.87 |
and…
Datatable - 2 (Dt_2)
| Invoice No | Quantity |
|---|---|
| 60003 | 100 |
| 60003 | 150 |
| 60003 | 200 |
| 60003 | 250 |
| 61086 | 300 |
| 60021 | 350 |
Here I want to compare ‘Invoice No’ of Dt_2 with ‘Invoice No’ of Dt_1, if Invoice No matches… then I want to extract complete row of that particular ‘Invoice No’ and should write in Dt_3 (Datatable - 3) as shown below
| Invoice No | Quantity | Item Code | Price |
|---|---|---|---|
| 60003 | 100 | 50052 | 0.98 |
| 60003 | 150 | 50123 | 0.92 |
| 60003 | 200 | 70026 | 0.85 |
| 60003 | 250 | 50416 | 0.75 |
| 61086 | 300 | 70125 | 0.96 |
| 60021 | 350 | 50215 | 0.87 |
Here I have used select method to extract entire row when ‘Invoice No’ matches, but I’m getting ‘50052’ as an output for four ‘60003’ Invoices.
I have used Lookup range as well, but I’m getting an error called ‘duplicates’
So is there any method or activity to resolve this issue…?
Please help me out of this…
Thanks in advance
Regards,
Sathwik.