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

Help Studio
, ,
1

Screenshot (77)
Screenshot (77)949×568 3.88 KB

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

2

Hey!

Try this…

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

Regards,
NaNi

3

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

4

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

5

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

6

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