Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 March 2022

Top 3 Topics with Most Views

Merge column in Datable & calculate value (LINQ) made by @fairymemay with 62 views.

How to do sum on dynamic columns in Excel made by @vinjam_likitha with 52 views.

The "Open Browser" Activity is missing made by @cui.z.1 with 46 views.

Top 3 Topics with Most Replies

Merge column in Datable & calculate value (LINQ) made by @fairymemay with 17 replies.

Unable to fetch data from excel when having value is 0 made by @shuklarchana001 with 12 replies.

How to do sum on dynamic columns in Excel made by @vinjam_likitha with 12 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 27 posts!

@ushu made 22 posts!

@ppr made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Remove part of string after last occurrence of delimiter "/"

we can do it with regex: [grafik] or using string method Split and join it again

This post made by @ushu received 1 likes!

How to terminate the UIPath process with a messagebox cancel button

@bencemarci You can terminate the process using terminate workflow activity. Please find the related work flow for this process MessageBox.zip (2.3 KB) Please use below video for more info on terminate workflow activity [UiPath Terminate Workflow Example]

This post made by @RAKESH_KUMAR_BEHERA received 1 likes!

UiPath Orchestrator New Version (2022) | By Rakesh

Learn how to use the new orchestrator UiPath user interface quickly. This video will show you how to navigate the new interface and upload a project to Orchestrator. This video will walk you through the process of successfully adding machines, robots as well as developing processes and deploying the UiPath studio built project. This video will serve as an excellent introduction to the new version of UiPath orchestrator 2022. [UiPath Orchestrator New Version (2022) | By Rakesh]

Top 3 Most Liked Solutions

This solution provided by @ushu received 1 likes!

How to terminate the UIPath process with a messagebox cancel button

@bencemarci You can terminate the process using terminate workflow activity. Please find the related work flow for this process MessageBox.zip (2.3 KB) Please use below video for more info on terminate workflow activity [UiPath Terminate Workflow Example]

This solution provided by @Yoichi received 1 likes!

I want to compare two datatable and put them in a new datatable

Hi, There are some ways to achieve this. One of them, we can use LeftJoin. The following will help you. Regards,

This solution provided by @Yoichi received 1 likes!

Looking Assistant with excel

Hi, If there is possibility it returns no row, first get datarow array using the following expression, then use CopyToDataTable when its length is larger than 0. arrDataRow = (From a In dt1.AsEnumerable Group Join b In dt2.AsEnumerable On a("bill number").ToString Equals b("bill number").ToString Into grp = Group From row In grp.DefaultIfEmpty() Select If(row Is Nothing, dtResult.LoadDataRow({a("Name"),a("amount"),a("bill number"),a("account"),a("Others"),"",""},…

---

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.