pls help i have 2 file excel, i need to check 2 condition :
if on file aaa column “KE 1” has “Passed” value and on file bbb has more than 70%, than write “Passed” on column “KE 2” in aaa file
if on file aaa column “KE 1” has “Passed” value and on file bbb has less than 70%, than write “Error” on column “KE 2” in aaa file
i have tried with this, but still not working
for each on aaa file, then
(From i In Enumerable.Range(0,bbb.Rows.Count)
Let r = bbb.Rows(i)
Where row(“KE 1”).toString.Equals(“Passed”) And Convert.ToDecimal(r(“Compliance”)) >= 0.70
Select i).DefaultIfEmpty(-1).First
dta.AsEnumerable.Zip(dtb.AsEnumerable,Function(a,b) Tuple.Create(a,b)).ToList().ForEach(Sub(t)
If t.Item1("KE1").ToString="Passed" AndAlso Convert.ToDecimal(t.Item2("Compliance").ToString)<0.7 Then
t.item1("KE2")="Error"
ElseIf t.Item1("KE1").ToString="Passed" AndAlso Convert.ToDecimal(t.Item2("Compliance").ToString)>=0.7
t.item1("KE2")="Passed"
End If
End Sub
)