For Each Row excel file. I want do action after complete last row as condition. How i can do, thank you
So you want to find the last row of that stock no. Is that correct ?
Yes last row of that stock no
Kindly check this out
Hope this helps
we can groupby the rows and refering to the last member of the group
(from d in dtData.AsEnumerable Group d by k=d(YourColNameOrIndex).toString.Trim into grp=Group Select r = grp.Last()).toList
then with a for each activity over ListLastMembers we can process the rows further
Hi @anh.nguyen !
Just to count the rows you can write Dt(DatatableName).Rows.Count
I want check by if condition: if last row of stock No. don’t do this action ?
Use Filter at the beginning & find the total row count to perform the check.
LastRow.xaml (8.6 KB)
This may be helpful.
maybe your requirement is about processing the groups and its members. So let us know your initial business case. Thanks