Data table group by total count and row value

[Parvathy (PS Parvathy)]

Hi @Jayaraman_Kumar

Check the below workflow file:

outputDataTable = (From row In inputDataTable.AsEnumerable() Group row By key = row("Column1") Into Group Let failedCount = Group.Count(Function(r) r("Column2").ToString() = "Failed") Let successCount = Group.Count(Function(r) r("Column2").ToString() = "Success") Select outputDataTable.Rows.Add({Group.Count(), failedCount, successCount})).CopyToDataTable()
Sequence3.xaml (12.1 KB)

Hope it helps!!