How to use LINQ filter on a DataTable in Uipath

Question

I have a Linq query written in C#. I don't know how to change it so that it works with UiPath.

The query finds all AccountNumber in the table and finds the sum of Remainder rows

var afterChange = listDate.GroupBy(account => account.AccountNumber)
   .Select(group => new 
   {
      AccountNumber = group.Key,
      Сurrency = group.Select(groupElement => groupElement.Сurrency).First(),
      Remainder = group.Select(groupElement => groupElement.Remainder).Sum(),
   })
   .AsEnumerable()
   .Select(x => new TableData 
   {
      Remainder = x.Remainder,
      AccountNumber = x.AccountNumber,
      Сurrency = x.Сurrency
   })
   .ToList();

So what about Currency? How it is retrieved is not a good way. — Svyatoslav Danyliv, Dec 20 '20 at 10:12
Currency is the same everywhere, you can simply copy it into the final table — user316997, Dec 20 '20 at 10:21

score 0 · Answer 1 · answered Dec 20 '20 at 10:25

Not familiar with UiPath, but your query needs correction.

var afterChange = listDate.GroupBy(account => new { account.AccountNumber, account.Сurrency })
   .Select(group => new TableData
   {
      AccountNumber = group.Key.AccountNumber,
      Сurrency = group.Key.Сurrency,
      Remainder = group.Sum(x => x.Remainder),
   })
   .ToList();

How to use LINQ filter on a DataTable in Uipath

1 Answers1