I use For Each Row read excel file to repeat DLV (Column H).
If see duplicate at Delivery No (H) will into For Each Row (small) to loop this rows
Ex: first loop will read 1st row DLV006 and into For Each Row (small) to loop 3row DLV006
and exit loop small and continue read 2nd row (loop big) but I donβt want loop 2nd DLV006, i want loop at DLV005
Hi @anh.nguyen
U can remove duplicates values based on that DLV column and if you need the entire data for further processing u can copy the previous data to new data table dt_New = dt.Copy()
I want remove loop duplicate row at For Each Row (big) with condition Customer Code (Column C): {βC00392β,βC01085β,βC00600β,βC01017β,βC01069β}. Other else loop normal
Ex: DLV003 CusCode: c00388 have 2row, condition will not remove duplicate. Thank you
update this to this in_DataTableDLV030.AsEnumerable.Select(function(row) row(4).ToString).Distinct.tolist().Except({"C00392","C01085","C00600","C01017","C01069"}).tolist()