Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 August 2023

Top 3 Topics with Most Views

Spliting the data within excel with regards policy number made by @ISBS_ROBOT with 56 views.

I want a method to achieve this made by @P-A-J with 55 views.

Scrape the data in a website made by @QUY_T_TAM_8.0_IELTS with 45 views.

Top 3 Topics with Most Replies

I want a method to achieve this made by @P-A-J with 24 replies.

For some reason, Read Range is not fetching the made by @sid04 with 18 replies.

Write cell excel activity made by @bhavana_kolli with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Nguyen_Van_Luong1 made 26 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @naveenkumarr received 2 likes!

Null values getting added to queue - Bulk add queue items

thanks @mkankatala and @lrtetala

This post made by @efelantti received 2 likes!

Table Extraction: Extract URLs

Seems like this is available in UiPath.UIAutomation.Activities = 22.4.10, but not in newer versions.

This post made by @Latifa received 2 likes!

Uploading queue items

Thanks a lot @Parvathy @lrtetala and @postwick

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Sub data table

we can group the data / split it to a list of datatables Assign Activity: TableList | DataType: List(Of DataTable) = (From d in Your DataTable.AsEnumerable Group d by k=d("num_chrono").toString.Trim into grp=Group Select t = grp.CopyToDataTable).toList

This solution provided by @tazunnisa.badavide received 1 likes!

Spliting the data within excel with regards policy number

Hey ! I have attached the workflow here ,Hope it might help You. Create Excel.xaml (10.8 KB)

This solution provided by @Yoichi received 1 likes!

I want a method to achieve this

I understand your points. How about the following? dt.AsEnumerable.GroupBy(Function(r) r("ID").ToString).OrderBy(Function(g) Cint(g.Key)).Select(Function(g) dt.Clone.LoadDataRow(new object(){g.Key}.Concat(Enumerable.Range(1,dt.Columns.Count-1).Select(Function(i) String.Concat(g.Select(Function(r) r(i).ToString)))).ToArray,False)).CopyToDataTable Sample20230816-3L (5).zip (15.3 KB) 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.