Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 April 2022

Top 3 Topics with Most Views

After updating v2022.4, the robot stops with an error "The workbook dose not exist." made by @nosawa with 49 views.

Dt issue made by @manoj_verma1 with 46 views.

Logic related question made by @meeraa with 41 views.

Top 3 Topics with Most Replies

License Issue, Uipath Robot does not exist made by @PALKUMARI_PATEL with 20 replies.

Access to Data Service with Power Bi made by @Benjamin_Wurth with 18 replies.

Postman, Swagger showing You are not authenticated! made by @Sanjit_Pal1 with 14 replies.

Top 3 Users Who Posted The Most

@ushu made 40 posts!

@Nithinkrishna made 38 posts!

@lakshman made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Getting List of Duplicate Rows with Unique Multiple Columns - LINQ

give a try at: (From d in dtData.AsEnumerable Let sk = String.Join(“_”,{“UID”,“Name”,“Gender”,“Age”}.Select(Function (x) d(x).toString.Trim)) Group d by k=sk into grp = Group Where grp.Count > 1 From g in grp Order by dtData.Rows.IndexOf(g) Select r=g).CopyToDataTable

This post made by @Ioana_D received 2 likes!

Extract entire line containing keyword

That works, thanks a lot!

This post made by @athira.somasekharan received 2 likes!

How to know if I am in the first row of a data table?

Hello @Lynx , Instead of for each loop, use For Each Row activity and in the property, assign a variable to index. Inside the loop, use an if condition to check if IndexVariable=0 Thanks! Athira

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Getting List of Duplicate Rows with Unique Multiple Columns - LINQ

give a try at: (From d in dtData.AsEnumerable Let sk = String.Join(“_”,{“UID”,“Name”,“Gender”,“Age”}.Select(Function (x) d(x).toString.Trim)) Group d by k=sk into grp = Group Where grp.Count > 1 From g in grp Order by dtData.Rows.IndexOf(g) Select r=g).CopyToDataTable

This solution provided by @athira.somasekharan received 2 likes!

How to know if I am in the first row of a data table?

Hello @Lynx , Instead of for each loop, use For Each Row activity and in the property, assign a variable to index. Inside the loop, use an if condition to check if IndexVariable=0 Thanks! Athira

This solution provided by @jack.chan received 2 likes!

Error Input string was not in a correct format?

sorry try this DT_Detail.AsEnumerable().Where(function(z) not z("APAPDT").ToString.Equals("") and not z("PAID_DATE").ToString.Equals("")).CopyToDataTable().AsEnumerable().Where(Function(w) Convert.ToInt32(w("APAPDT").ToString.Trim) >= startDatePeriod And Convert.ToInt32(w("APAPDT").ToString.Trim) <= endDatePeriod And Convert.ToInt32(w("PAID_DATE").ToString.Trim) >= startDatePeriod And Convert.ToInt32(w("PAID_DATE").ToString.Trim) <= endDatePeriod).CopyToDataTable()

---

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.