Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 November 2022

Top 3 Topics with Most Views

How to Copy a DataTable? made by @Sanjeevi with 46 views.

Iterating radio buttons made by @philwaller with 43 views.

Open File that contains the specific name made by @lq_c with 37 views.

Top 3 Topics with Most Replies

How to Sum all the values in multiple column index using LINQ made by @Sidney_Vogel with 9 replies.

Input data given in excel need to get the total quantity made by @VB_Chel with 9 replies.

How to count variable starting from 01,02 ..... 10 and so on made by @enthusiastic with 8 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 31 posts!

@Yoichi made 18 posts!

@Rahul_Unnikrishnan made 8 posts!

Top 3 Most Liked Posts

This post made by @Sanjeevi received 2 likes!

How to Copy a DataTable?

There are two ways you can copy a DataTable with structure and data to another DataTable. You can copy a DataTable to another DataTable using Filter Data Table activity. You can add Source DataTable in the Input DataTable section and the Destination DataTable in the Filtered DataTable section. You can leave the Filter Rows and Output Columns values as it is. [Filter Data Table] You can use DataTable.Copy method in an Assign activity. [Assign Activity Copy] DataTable.Clone Method If y…

This post made by @Yoichi received 2 likes!

How to Sum all the values in multiple column index using LINQ

Hi, If you need sum value of specific column, the following help you. dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(4).ToString)) The above returns sum value of 4th column of the datatable (0-base index) Regards,

This post made by @Sidney_Vogel received 1 likes!

How to Sum all the values in multiple column index using LINQ

@Yoichi you are a genius, this worked perfectly, thank you so much for this, this is great. Is there a way to only get the value, instead of an array? I guess could add (indexnumber) at the end of the array, like this: Enumerable.Range(dt.Columns.Count-5,5).Select(Function(i) dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(i).ToString))).ToArray()(1) But is there another way to get just the individual sum of the column and not an array?

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to Sum all the values in multiple column index using LINQ

Hi, If you need sum value of specific column, the following help you. dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(4).ToString)) The above returns sum value of 4th column of the datatable (0-base index) Regards,

This solution provided by @sangeethaneelavannan1 received 1 likes!

Is OCR of Uipath free?

@Nitiwat_Chunprapanusorn Please download the below package from manage package window and it is free [image] The UiPath Document OCR activity is optimized for usage on scanned documents and images of documents. The UiPath Screen OCR activity is optimized for the usage on-screen images.

This solution provided by @Gokul001 received 1 likes!

This message appears after I changed from Legacy to Windows compatibility

HI @Larry_Anthony_Jacobo_Zar1 Welcome to uipath community It may be the Double Quotation issue " Try to Re enter the expression again String.Join(Environment.NewLine,(From r In dt_AgrupacionAConciliar Select r.item("Nº documento"))) Check out this thread Regards Gokul

---

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.