Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 May 2023

Top 3 Topics with Most Views

Add Column in data table with modified value made by @ashwini.mali with 40 views.

Capture the element in the children window made by @jackie.yue with 37 views.

Read range(Settings and Constants sheets) made by @170290064 with 34 views.

Top 3 Topics with Most Replies

Add Column in data table with modified value made by @ashwini.mali with 20 replies.

Read range(Settings and Constants sheets) made by @170290064 with 17 replies.

Orchestration Process (Foreground and Background issue) made by @anusha2 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@ushu made 19 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

How to Merge cells and sum values if rows are same

Hi, Hope the following sample helps you. [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.First()(1),g.First()(2),g.Sum(Function(r) CInt(r("Amount")))},False)).CopyToDataTable Sample20230520-4L.zip (7.0 KB) Regards,

This post made by @Anil_G received 1 likes!

How to Merge cells and sum values if rows are same

@sathish_Kumar6 Read the data in to a datatable dt…now use below in the assign activity Use Build datatable activity with outdt and 4 columns as strings outdt = (From d In Dt.AsEnumerable() Group d By k=d("Name").toString.Trim Into grp = Group Let gSum =grp.Sum(function(x) CDBL(x("Amount").ToString).ToString Let ra = New Object(){k,grp.FirstOrDefault(1).ToString, grp.FirstOrDefault(2).ToString,gSum} Select r = outDt.Rows.Add(ra)).CopyToDataTable() Cheers

This post made by @Yoichi received 1 likes!

Read range(Settings and Constants sheets)

Hi, This error shows Config.xlsx is already opened. So, can you try either of the following? Use UseExcelFile and RearRangeX instead of ReadRangeWorkbook. or Close Config.xlsx before the ReadRangeWorkbook. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to Merge cells and sum values if rows are same

Hi, Hope the following sample helps you. [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.First()(1),g.First()(2),g.Sum(Function(r) CInt(r("Amount")))},False)).CopyToDataTable Sample20230520-4L.zip (7.0 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Could not Download Attachments from Gmail

@TienGiang Please check the retrieve attachments property in the for each email activity [IMG_5776] Hope this helps Cheers

This solution provided by @Yoichi received 1 likes!

Read range(Settings and Constants sheets)

Hi, First set empty at Range property of ReadRange [image] Next, the following OrchestratorQueueFolder data causes error. For now can you try to set empty? [image] Regards,

---

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.