Can any one help me to select multiple common data and different data?

here, this is the case, the pr have some different materials and also every PR has different IRS and for the IRS it may have same or different suppliercodes

in the above the suppliercode is same for a,b,f so create po 1 time instead of 3 times with x xupplier code

and c,e instead of 2 pos create 1 with y supplier code

for d create 1 po

if a,bc,d,e,f contains same suppliercode then create 6 different pos

can anyone please suggest the logic to implement
@THIRU_NANI @Gangadhar_Athili


Try this…

Dt.DefaultView.ToTable(True,"Supplier-Code po creation")


hey, I am just giving that screenshot for understanding purpose, the suppliercode is coming from 1 tcode, and IR, Materailno, PRs coming from queue

dt1.AsEnumerable.except( dt2.AsEnumerable(),system.Data.DataRowComparer.Default).CopyToDataTable

this query for mismatched data

and for common data

dt1.AsEnumerable.union( dt2.AsEnumerable(),system.Data.DataRowComparer.Default).CopyToDataTable

But this is not data table, supplier code coming from 1 tcode and other are coming from queue

can you please tell me the detailed steps
@Veera_Raj @THIRU_NANI