Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 March 2021

Top 3 Topics with Most Views

Split excel into Unique and Duplicate Rows made by @Yudhisteer_Chintaram1 with 35 views.

引数の使い方 made by @0st0eDSep9 with 31 views.

Log message return NULL exception with UiPath.MicrosoftTeams.Activities made by @q.gio with 29 views.

Top 3 Topics with Most Replies

引数の使い方 made by @0st0eDSep9 with 18 replies.

Retrieve all Rows of a particular column from Datatable and assign it to an DataRow[] made by @Jadeja_Chandravijaysinh with 15 replies.

Sum of column where row is of a certain type made by @atomic with 14 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 34 posts!

@Yoichi made 31 posts!

@Hiba_B made 27 posts!

Top 3 Most Liked Posts

This post made by @Pravin_Patil1 received 4 likes!

Pause Automation

Better idea to take an element exist or wait element to appear activity and increase timeout property to 30 min… Just for information, If you want to do it in attended mode as one time activity then In UiRobot section we have an option to pasue… Refer below… [image]

This post made by @seanrockvz13 received 3 likes!

Most Active Users - New community feature

Cool Feature Pablito!

This post made by @Vibhor.Shrivastava received 3 likes!

Techgig Code Gladiators 2021 virtual hackathon is live

Code Gladiators is the largest and annual coding battle in India and UiPath is an exclusive automation partner, 3rd year in a row for the 2021 Techgig Code Gladiators virtual hackathon. All RPA enthusiasts worldwide are invited to participate and showcase their skills. So, what are you waiting for? Create your team or participate individually by Registering HERE Think of your next big idea, we are looking forward to seeing ideas & solutions based on the following categories Category # 1 : Aut…

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Sum of column where row is of a certain type

Hi @atomic to calculate the sum of RA use the below linq query dt1.AsEnumerable().Where(Function(row) row(“Type”).ToString.Equals(“RA”)).Sum(Function(row) Cint(row(“Amount”).ToString)) use the same way for other values too apart from RA Try this Regards, Nived N Happy Automation

This solution provided by @ppr received 2 likes!

Join data table activity - left Join not working as expected

we do see that 123 occurs twice. So the nature of join will create follwoing: take first 123 from dt1 join it with 123-pen from dt2 123-pen from dt2 take the second 123 from dt1 join it with 123-pen from dt2 123-pen from dt2 thats why th 4 rows are found. In such cases removing duplicates e.g in dt2 or custom join logic can help. here is just to rule when left 123 is picked up by which rule the both 123 rows from dt2 are to select for the pairing.

This solution provided by @Yoichi received 2 likes!

項目を選択←リストをデータテーブル型で取得

こんにちは 一度リボンメニューにあるスクリーンスクレイピングウイザードを試してもらえますでしょうか？ スクレイピングメソッドをフルテキスト、ネイティブそれぞれでどうなるか見てもらえると良いかもしれません。

---

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.