How to filter DT if it contains no rows. Errors "source contains no DataRows"

Hi @Shinjid

You can put an assign activity inside the if activity

in_DT_Money.AsEnumerable.Where(Function(x)x("Date").ToString.Equals(item.ToString)AND x("MoneyType").ToString.Equals("USD")).Count > 0

And if the count is greater than 0, then use the assign activity you are referring inside the then, else do nothing and continue with the loop.

Or of you want to put the assign before if activity,use assign inside the try catch activity.

Thanks

1 Like