Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 March 2022

Top 3 Topics with Most Views

Iterating through email attachments made by @Androk with 65 views.

I had one pdf with 100 pages which contains data of cars compnay. can i split into 4 documents based on page no and company name? made by @MitheshBolla with 52 views.

Merge two database with different Column Name made by @jvillalba9221 with 52 views.

Top 3 Topics with Most Replies

Unable to run script after disconnecting VM / after doing system shutdown made by @Mathkar_kunal with 26 replies.

Merge two database with different Column Name made by @jvillalba9221 with 20 replies.

Get outlook mail message ERROE made by @Zoeyu with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 58 posts!

@ppr made 39 posts!

@Nithinkrishna made 25 posts!

Top 3 Most Liked Posts

This post made by @zell12 received 2 likes!

Your feedback on UiPath Apps can earn you a certification voucher - ends March 9

Hi Maciej! @loginerror below are my inputs What integration to an automation platform are you looking forward to see in UiPath Apps and why? Direct integration/native compatibility with Action Center. One such use case of this would be an App/Unified dashboard being used by a pool of users, where they could select a batch of items that will then be routed to an Approval Matrix queued and orchestrated via Action Center. Once approved/rejected/hold, the status will then be reflec…

This post made by @Yoichi received 2 likes!

重複データを抽出したいです

こんにちは 以下お試しください dt = dt.AsEnumerable.Where(Function(r) dt.AsEnumerable.Count(Function(r2) r2("Column1").ToString=r("Column1").ToString)>1).CopyToDataTable()

This post made by @Sadmim_Hossain1 received 2 likes!

Read data in column and compare (Fast)

It’s probably because of the excel file. You can either change the data format after this process is completed. (alternative: you can also add a ’ before the text when it writes in the cell.) It is taking time because of its’ dynamic process. It opens and reads the excel file each time, searches the table to get the amount of the particular APPLAN. If we could fix the DataTables; as done in the previous workflow; the process would have been way faster.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

重複データを抽出したいです

こんにちは 以下お試しください dt = dt.AsEnumerable.Where(Function(r) dt.AsEnumerable.Count(Function(r2) r2("Column1").ToString=r("Column1").ToString)>1).CopyToDataTable()

This solution provided by @nikhil.girish received 2 likes!

Copy data from excel column

Hi @Aishwarya_Bhargava refer below link hope this helps Thanks

This solution provided by @Sadmim_Hossain1 received 2 likes!

Loop sheet name?

Hello, Basically, it totally depends on how you are going to use the DT. The idea goes like this when you are going through the DT as per row you are also reading the Sheet’s DataTable. You can do it by separating the sheet names into an array and then reading the data table individually with For Each Activity. This For Each activity will iterate through the array and read each of the sheets. I have created a sample workflow that will be able to read all the sheets separated by a comma. You ca…

---

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.