Comparing 2 Datatable using 3-4 using columns using linq

Help Studio
, ,
1

Hi Team,

I want to compare 2 datatables as given below, i want to check the unrestricted column, with respect to material, storage location, unit and plant. For particular material, plant, storage location and unit check whether the restricted in smaller or 2nd datatble is grater than or equal to 0. If it is less than zero stores the material in a new datatable. Using linq
Datatable 1:

image
image1252×556 108 KB

Data table2:
[Material,Storage Location,unit ,plant,unrestricted
FB1410XL,0011,PC,LI29,5
FCCVS095,0011,PC,LI29,5
F208AXXL,0011,PC,LI29,1
F208CXXL,0011,PC,LI29,1
F208BXXL,0011,PC,LI29,1
F209B0XL,0011,PC,LI29,1
F209A0XL,0011,PC,LI29,1
F209C0XL,0011,PC,LI29,1
FCOX8100,0011,PC,LI29,6
FCOX8090,0011,PC,LI29,6
F31OL0XL,0011,PC,LI29,1
T21NB00L,0011,PC,LI29,1
T21BG0XL,0011,PC,LI29,1
F31BL00S,0011,PC,LI29,1
FCM100XL,0011,PC,LI29,1
FCB130XL,0011,PC,LI29,1
FCC0600L,0011,PC,LI29,2
FCB0300L,0011,PC,LI29,1
FCN1100L,0011,PC,LI29,1
FCP140XL,0011,PC,LI29,1
FCB020XL,0011,PC,LI29,1
]

Please help.

3

@Yoichi Please help.