Forum Engagement Daily Reports

[system]

Daily Forum Report | 07 February 2022

Top 3 Topics with Most Views

How to delete selected multiple columns in an excel file made by @Sreekar_Mulinti with 53 views.

How to concat common rows in excel file and and write into single cell made by @Sreekar_Mulinti with 46 views.

Date for Each Row made by @ShadowZ with 45 views.

Top 3 Topics with Most Replies

How to concat common rows in excel file and and write into single cell made by @Sreekar_Mulinti with 24 replies.

How to delete selected multiple columns in an excel file made by @Sreekar_Mulinti with 22 replies.

Date for Each Row made by @ShadowZ with 20 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 31 posts!

@ppr made 24 posts!

@Sreekar_Mulinti made 22 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Linux Robots #2A: Essential Docker Basics & Cross-platform Automations

Hello Community, Following the Part 1 video on Linux Robots that dropped here last week, the Part 2A video goes the extra mile to set the stage before Linux Robots can be deployed. This involves familiarizing ourselves with some much needed Docker essentials. Obviously, audience can skip sections of coverage that they’re already familiar with. The Part 2A video track covers the following topics: 00:33 - Prologue 04:08 - Essential Docker UI Fundamentals 08:06 - Essential WSL 2 (Windows…

This post made by @Cristian_Negulescu received 2 likes!

UiPath Orchestrator webhooks use-case | UiPath in 5 minutes | Ep:18

UiPath Orchestrator webhooks use-case | UiPath in 5 minutes | Ep:18 [UiPath Orchestrator webhooks use-case | UiPath in 5 minutes | Ep:18] #uipath #webhooks #5minutes

This post made by @Krutika_Kotkar received 2 likes!

Data Scraping from PDF with multiple pages and tables into excel

scrape the entire table and use filter data table to filter rows based on your condition

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Dynamic Sum of Array Elements

Hey @Aswin_Ramesh You need to do this as below, once you get the number N from the input dialog… arrNum.Take(N).Sum() The above statement will give you the sum of the elements until the size mentioned in the input dialog You can use that in the assign statement & store it in a variable as well Hope this helps Thanks #nK

This solution provided by @Palaniyappan received 1 likes!

How to neglect a particular row in excel

Hi Hope the below steps would help you resolve this Let’s take like you have the datatable read and named as dt Now there are two scenarios If you want to have the first row after header but should process that means Use a FOR EACH ROW activity and pass dt as input Inside the loop use a IF condition like this NOT dt.Rows.IndexOf(CurrentRow).Equals(0) IF TRUE means it goes to THEN block and inside that have all the activities to process all the rows except first row Or There is an…

This solution provided by @supermanPunch received 1 likes!

ERROR IN FUCTION GROUP BY

Hi @salvatore.quimi , Could you try Updating your Query to the Below and Check : (From d In dtPv.AsEnumerable Group d By k=d("Soc.").toString.Trim, k2= d("Codici iva").ToString.Trim, k3=d("Registro").ToString.Trim,k4=d(" M").ToString.Trim Into grp=Group Let cs1 = grp.Sum(Function (x) Convert.ToDouble(If(x(" Imp. base imponibile").toString.Trim.IsNumeric,x(" Imp. base imponibile").toString.Trim,"0"))) Let cs2 = grp.Sum(Function (x) Convert.ToDouble(If(x(" IVA vendite").toString.Trim.IsNumeric,x…

---

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.