Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 May 2021

Top 3 Topics with Most Views

データテーブルで横に並んだ情報を縦に整理する made by @kaori.horiuchi with 33 views.

Linq Query on Group By and Sum made by @tmond with 32 views.

Remove &ZeroWidthSpace Unicode character from a string made by @phaniraj.raichooti with 30 views.

Top 3 Topics with Most Replies

Get Index of First Empty Row made by @tilarapiyush with 18 replies.

Cannot Automate a desktop application made by @Penganimation with 11 replies.

Need help with dynamic process made by @ShengChao_Soh with 11 replies.

Top 3 Users Who Posted The Most

@Pankaj.Patil made 9 posts!

@ashwini.magar92 made 8 posts!

@ppr made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to remove datatable1 form datatable2 (datatable2 contains datatable1)

give a try on Assign activity: left side: drResult | Datatype: List(of DataRows) right side: datatable2.Except(datatable1, DataRowComparer.Default).toList If activity: Condition: drResult.Count > 0 then: dtFiltered = drResult.CopyToDataTable else: dtFiltered = datatable2.CopyToDataTable dtFiltered is of datatype: DataTable

This post made by @ppr received 2 likes!

Linq Query on Group By and Sum

@tmond Welcome to the forum We can do it with folloing flow: [grafik] (From d In dtData.AsEnumerable Group d By k=d("Col3").toString.Trim Into grp=Group Let gs = grp.Sum(Function (x) CInt(x("Col2").toString)) Let raa = grp.Select(Function (g,i) If(i=0,g.ItemArray.Append(gs).toArray,g.ItemArray.Append(Nothing).toArray)).toarray From m In raa Select dtResult.Rows.Add(m)).CopyToDataTable And will get: [grafik] Find starter help here: GroupBy_1Col_AddSumToFirstMember.xaml (9.0 KB) Also have…

This post made by @mdiaz2307 received 1 likes!

Generic Value not availalble

Cheers mate.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Linq Query on Group By and Sum

@tmond Welcome to the forum We can do it with folloing flow: [grafik] (From d In dtData.AsEnumerable Group d By k=d("Col3").toString.Trim Into grp=Group Let gs = grp.Sum(Function (x) CInt(x("Col2").toString)) Let raa = grp.Select(Function (g,i) If(i=0,g.ItemArray.Append(gs).toArray,g.ItemArray.Append(Nothing).toArray)).toarray From m In raa Select dtResult.Rows.Add(m)).CopyToDataTable And will get: [grafik] Find starter help here: GroupBy_1Col_AddSumToFirstMember.xaml (9.0 KB) Also have…

This solution provided by @StefanSchnell received 1 likes!

SAP Read ICDataFlowCtrl (interactive flowchart)

@jack.chan Hello Jack, this control is embedded in an SAP docking control and it is not supported by the SAP GUI Scripting. Best regards Stefan

This solution provided by @prasath17 received 1 likes!

Write range, append function not working

@Dennon_Seet - I was able to achieve it using the counter … [image] Workflow file: WriteRange_Append.zip (159.4 KB) Note: Save for Later activity is available in the version starting 20.10.6 i guess… Hope this helps…

---

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.