Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 July 2024

Top 3 Topics with Most Views

Debug question made by @A_Learner with 57 views.

DataTable Remove duplicate rows made by @A_Learner with 50 views.

Please findout the error,, made by @mukeshreddy4569 with 50 views.

Top 3 Topics with Most Replies

How to get + value made by @bhanu.priya2 with 17 replies.

Can anyone help me with this made by @mohamed.saty2012 with 16 replies.

How to filter column and do sumn made by @bhanu.priya2 with 13 replies.

Top 3 Users Who Posted The Most

@bhanu.priya2 made 26 posts!

@lrtetala made 15 posts!

@mkankatala made 11 posts!

Top 3 Most Liked Posts

This post made by @Venkat4 received 2 likes!

Up-to-date on the latest of the UiPath Platform? Check with our Quiz! Win your Badge!

Hi @loredana_ifrim Thanks for the initiative. I have successfully completed the quiz. [image] [JuneUpdates]

This post made by @Vikas_M received 2 likes!

Up-to-date on the latest of the UiPath Platform? Check with our Quiz! Win your Badge!

Excited to share that I completed the UiPath quiz and earned my certificate! Thanks to the UiPath team for the engaging and insightful quiz. It’s a fantastic way to stay updated and grow within the UiPath ecosystem. I encourage everyone to participate and challenge themselves! [image]

This post made by @Anil_G received 2 likes!

Linq_Filter_DataTable with Update row Items

@Balachander_Pandian follow the steps Read data into datatable dt Use the following in assign to populate remarks columns(Assumption is its already present if not then add the column first) dt.Columns("Remarks").Expression = "IIF([GST From Column]=[GST To Column],'True','False')" Use assign with dt.AsEnumerable.Where(function(x) x("Remarks").ToString.Equals("True")).Concat({dt.NewRow}).Concat(dt.AsEnumerable.Where(function(x) x("Remarks").ToString.Equals("False"))).CopyToDataTable Write the d…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Linq_Filter_DataTable with Update row Items

@Balachander_Pandian follow the steps Read data into datatable dt Use the following in assign to populate remarks columns(Assumption is its already present if not then add the column first) dt.Columns("Remarks").Expression = "IIF([GST From Column]=[GST To Column],'True','False')" Use assign with dt.AsEnumerable.Where(function(x) x("Remarks").ToString.Equals("True")).Concat({dt.NewRow}).Concat(dt.AsEnumerable.Where(function(x) x("Remarks").ToString.Equals("False"))).CopyToDataTable Write the d…

This solution provided by @bavyaravu133 received 1 likes!

How to find Duplicated rows in Excel,,,,,,,,,,

@sagarinavya6 Try this: ( From row In dt Group row By a = row("CName").ToString.Trim Into grp = Group Where grp.Count > 1 Select grp.ToList ).SelectMany(Function(x) x).CopyToDataTable

This solution provided by @Anil_G received 1 likes!

DataTable Remove duplicate rows

@A_Learner It checks for all columns…if whole of row is same then the row is considered as duplicate If you need partial then you need to use linq cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.