LINQ | LINQ Pivot Table Aggregation | Sum LINQ Pivot | LINQ Uipath | Uipath Tutorials | Coderslobby
LINQ | LINQ Pivot Table | Sum Using LINQ Pivot | Count Using LINQ Pivot | Aggregation Methods in LINQ Pivot | LINQ Uipath | Uipath Tutorials | Coderslobby
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
Code:- Query
dtResult - (From row in dtTest.AsEnumerable
Group row By Key = New With{
Key.Region = row("Region").ToString,
Key.Item = row("Item").ToString
}into grp = Group
Select dtResult.LoadDataRow(New Object(){
Key.Region,
Key.Item,
grp.Sum(Function(y) Convert.ToDouble(y("Units").ToString)),
grp.Count
},True)).OrderBy(Function(x) x("Region").ToString).CopyToDatatable
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🎧In this video tutorial, you will learn
Different Aggregation methods using linq pivot?
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🖥️Video Summary 👉
In video will learn how find the sum and count using linq pivot.
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
Hope you found this video useful. Please like, share the video, and subscribe to our channel. This will motivate us to create more good content. Thanks!
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🎧Do watch our Other Videos 👉
Uipath👉 • UiPath Tutorials
Uipath LINQ👉 • Linq Uipath
VBA👉 • VBA Tutorials
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
-------------------------------SOCIAL-------------------------------
🛠️ If you have any doubt or query, drop us an email: [email protected]
👥Facebook: https://fb.me/CodersLobby
📸Instagram: / coderslobby
📱WhatsApp: 8558919766
----------------------------------------------------------------------