Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 December 2021

Top 3 Topics with Most Views

VBA Code-- Help made by @Anjali_Rani with 50 views.

RegEx: Extact keywords from document made by @Yudhisteer_Chintaram1 with 42 views.

Filtering big data tables made by @yulya with 38 views.

Top 3 Topics with Most Replies

RegEx: Extact keywords from document made by @Yudhisteer_Chintaram1 with 14 replies.

Nested for each: Excel file being used by another process made by @m1k9801 with 13 replies.

VBA Code-- Help made by @Anjali_Rani with 12 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 25 posts!

@Robinnavinraj_S made 22 posts!

@kirankumar.mahanthi1 made 22 posts!

Top 3 Most Liked Posts

This post made by @alexdjerassi received 3 likes!

Alex Djerassi

Alex Djerassi from the united states, We use UiPath in our organization. Unipath tool has many commands with which we can automate most manual functions, we can also customize the orders to fit our requirements, the evolution of the platform. it also helps users in a high execution of processes and reduces the expenses of automation of their organizations, also this application can also be used to improve the client experience, the execution of SQL queries helps to access the database easily,

This post made by @kirankumar.mahanthi1 received 3 likes!

Merge two datatables and place it in one sheet

Hi @Tabbu , Merge data table activity have two input arguments one is source data table and destination datatable. the mechanism of the merge is destination will come first and source come second. So use the data table you want first in the destination and second should be in source. the main point is for merging data table you should have same column names. thanks

This post made by @shreyash_shirbhate received 2 likes!

How to publish in document understanding folder

Hey @SH_94, Just select the folders in UiPath Studio in which you want to publish the package. Like below. [image] Also, while creating the folder on Orchestrator, make sure you select Create a new package feed option as below. [image] I hope this will help you! Thanks!

Top 3 Most Liked Solutions

This solution provided by @shreyash_shirbhate received 2 likes!

How to publish in document understanding folder

Hey @SH_94, Just select the folders in UiPath Studio in which you want to publish the package. Like below. [image] Also, while creating the folder on Orchestrator, make sure you select Create a new package feed option as below. [image] I hope this will help you! Thanks!

This solution provided by @Robinnavinraj_S received 2 likes!

While extracting the data trough document understing .i had used export extraction result, and writing to excel. i am getting data twice (simplefiled and simple field formated). how to avoid simple field format?

Hi @Mithesh_Reddy_Bolla You can directly gave tables in write range Ex:Dataset_var.Tables(0)- Non table values Dataset_var.Tables(2)- table values Kindly refer the below image for reference [example] Thanks, Robin

This solution provided by @Yoichi received 1 likes!

Filtering big data tables

Hi, Can you try the following sample? [img20211228-a1] dtKeep = dt2.AsEnumerable.Where(Function(r) dt1.AsEnumerable.Select(Function(r2) r2("Filtering Column").ToString).Contains(r("NoDoc").ToString)).CopyToDataTable() dtRemove = dt2.AsEnumerable.Where(Function(r) not dt1.AsEnumerable.Select(Function(r2) r2("Filtering Column").ToString).Contains(r("NoDoc").ToString)).CopyToDataTable() Sample20211228-a1.zip (18.2 KB) Note : This workflow outputs 2 datatable : one is to keep record which exi…

---

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.