Multiple Values To A column

@dutta.marina

Try this in invoke code…send dt1 and in/out and dt2 as in

dt1.AsEnumerable.ToList.ForEach(Sub(r) r("MisMatchedData") = r("MisMatchedData").ToString + "," + If(dt2.AsEnumerable.Any(function(x) x("QuoteNumber").ToString.Equals(r("QuoteNumber").ToString)), dt2.AsEnumerable.Where(function(x) x("QuoteNumber").ToString.Equals(r("QuoteNumber").ToString))(0)("GeneralClause_Field").ToString,"").Trim(","c))

Cheers

1 Like