How to set the activity to just happened once even it meets the conditions for more than two row

[indrajit.shah (iamvicky)]

Can we try to groupby the delivery info column? in that way, the column having duplicates records will be grouped and will have unique records only and it won’t repeat while checking condition.

For example

Extracting relatable data from a Data table

I have a solution but again we have to maintain the date format which is not coming correct but its picking the correct data - Can you give it a try and let us know? (From d In DT2 Group d By k=d("Date").ToString.Trim Into grp=Group Select grp.Last()).CopyToDatatable I am looking for input from experts like @Palaniyappan @NIVED_NAMBIAR and @ppr , to correct my wrong or some other solution.