Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 April 2024

Top 3 Topics with Most Views

🙋‍♀️ 🙋‍♂️ Beginners Learning Challenge #4 in the UiPath Forum Community! made by @pradeep_ch with 267 views.

If condition syntax with date made by @mark_rajkumar1 with 69 views.

【初心者】データテーブルから重複行の削除 made by @ando0403.primal with 51 views.

Top 3 Topics with Most Replies

If condition syntax with date made by @mark_rajkumar1 with 14 replies.

【初心者】データテーブルから重複行の削除 made by @ando0403.primal with 10 replies.

Copy a file and rename the file before adding to the folder made by @Ellen with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@ashokkarale made 23 posts!

@Yoichi made 12 posts!

Top 3 Most Liked Posts

This post made by @pradeep_ch received 4 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

Dear Community , Are you ready for Beginners Learning Challenge #4: Excel application ? Let’s enhance your UiPath skills further with the help of our @pathrudu , @AutomationX_by_Kiran and @loredana_ifrim . Here is the Challenge #4 we have in store for you Challenge_4_input.xlsx (10.8 KB) Take an Excel File, Where it has 3 sheets. First sheet has 4 columns (F.Name, L.Name, DOB, Address) of information and Second sheet has 3 columns (F.Name, …

This post made by @nikhilesh578 received 4 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

All the best👍for challenge 4. Kudos to the team @pradeep_ch , @pathrudu , @AutomationX_by_Kiran , @loredana_ifrim

This post made by @Anil_G received 4 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

Some fun ExcelAsDB.zip (12.4 KB) cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

【初心者】データテーブルから重複行の削除

グルーピングの問題なのでそれ用のメソッドを使う方法を共有します。 [image] dt.AsEnumerable.GroupBy(Function(r) r("管理№").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.First().Item("請求年月"),g.First().Item("実績年月"),g.Key,g.Sum(Function(r) CDec(r("実績（件１）"))),g.Sum(Function(r) CDec(r("実績（件２）"))),g.Sum(Function(r) CDec(r("実績（個数）"))),g.Sum(Function(r) CDec(r("実績（Ｍ３）")))},False)).CopyToDataTable() サンプル Sample20240402-1.zip (3.6 KB)

This solution provided by @muktadir received 1 likes!

How to add manual increment in Write Celll

Hi, Please try the following [image] this will enter the data after the last row of the data table.

---

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.