Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 March 2024

Top 3 Topics with Most Views

Read Range Workbook: Index was outside the bounds of the array made by @Hemant_Deshmukh with 52 views.

Filter datatable fetched from SAP ,future date should be present made by @jain.priti26 with 52 views.

How to use assign activity for following case made by @NISHITHA with 50 views.

Top 3 Topics with Most Replies

How to extract the exact value from the other sheets without rounding the decimals made by @anjani_priya with 23 replies.

Filter datatable fetched from SAP ,future date should be present made by @jain.priti26 with 22 replies.

How to compare two data table made by @copy_writes with 19 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 37 posts!

@Yoichi made 22 posts!

@mkankatala made 22 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

UiPath Excel error with Office 365

Hi @A_Learner Check the below thread, Hope it helps!!

This post made by @Parvathy received 2 likes!

Whats the Difference Between uipathActivites

Hi @devasaiprasad_K dt.columnscount: This property is used with UiPath Database activities like the “Execute Query” activity. It’s accessed directly as a property of the DataTable variable. It returns an integer representing the number of columns in the DataTable. dt.columns.Count: This property is used with standard DataTable operations in UiPath, such as manipulating DataTables using VB.NET. It’s accessed through the Columns property of the DataTable variable, which returns a collectio…

This post made by @Biswajeet_kumar received 2 likes!

Getting issue while Substracting extracted dates

Hi @madhavraichur25 Welcome to the community! This can be achieved using an assign instead of three with following steps: create a variable named No_Of_days as Int64 by selecting browse for types. In the value use this expression DateDiff(DateInterval.Day,CDate(now.ToString(“MM/dd/yyyy”)),Cdate(DateTime.ParseExact(your_date_String_Var.Trim,“dd/MM/yy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”))) Cheers! Biswajeet Kumar

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

How to remove duplicate values

Hi @Chippy_Kolot Try this [image] DT1.AsEnumerable() _ .GroupBy(Function(row) New With { _ Key .Name = row.Field(Of String)("Name"), _ Key .Phno = row.Field(Of Double)("Phno") _ }) _ .Select(Function(Group) Group.First()) _ .CopyToDataTable() Test (6).xlsx (9.2 KB) Regards,

This solution provided by @tazunnisa.badavide received 1 likes!

Linq for Full outer join

UiPath | LINQ Join Function | Inner Join | Left Outer Join | Right Outer Join | Full Outer Join - YouTube

This solution provided by @Anil_G received 1 likes!

Help related to choose right UI path License for my use case

@hvishwaradhya yes you can if the process is background 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.