Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 February 2023

Top 3 Topics with Most Views

How do i add flow decision activity on studio web? and loop it as in studiopath normal made by @Arvind_Karthigayan with 71 views.

How to find count of today date in excel based on input value made by @Raja.G with 35 views.

Number Filter UiPath made by @Real.Downey with 34 views.

Top 3 Topics with Most Replies

Issue with the selector made by @govindreddy_nagireddy with 18 replies.

Write Range Workbook: Object Reference Not set to an instance of an Object_Error while getting Queue Items from Orchestrator made by @Alekhya_Gandhi with 13 replies.

An activity that breaks the loop in the flowchart after a certain amount of repetitions made by @eduardo34 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@rikulsilva made 14 posts!

@govindreddy_nagireddy made 12 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How can you pass different DataTables in .rows.Items

Hi, FYI, another approach without if: dict = New Dictionary(Of Boolean, DataTable)From{{true,dtA},{false,dtB}} dict is Dictionary<Boolean, DataTable> type Then, the following will work. dict(condition).Rows(0).Item(0).ToString [image] Sample20230206-1L.zip (2.7 KB) Regards,

This post made by @NiesonF received 1 likes!

How can you pass different DataTables in .rows.Items

This worked perfectly!

This post made by @Boopathi.M received 1 likes!

How to click on a Ui Element only if it contain a specific text ( out of many similar Ui element )

Hi @celie.mccook Use click activity and indicate it on your name and analyze the selector if any element is unique for that particular name like aaname or text and you can pass variable dynamically in the selector to click on your name or any other name you wish to click You can see Data Extract example in UiPath site Thanks

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How can you pass different DataTables in .rows.Items

Hi, FYI, another approach without if: dict = New Dictionary(Of Boolean, DataTable)From{{true,dtA},{false,dtB}} dict is Dictionary<Boolean, DataTable> type Then, the following will work. dict(condition).Rows(0).Item(0).ToString [image] Sample20230206-1L.zip (2.7 KB) Regards,

This solution provided by @rikulsilva received 1 likes!

How could I separate one column into multiple colums with their values?

@pprin001 Hi Use Read CSV activity and pass the column separator (,) The output is a DataTable that you can save

This solution provided by @Anil_G received 1 likes!

Which country has most points?

@Comet Did you create a datatable using build Datatable as stated above? Also try this, I have added check to rating if it is a number Newdt = (From d In ExtractedTable.AsEnumerable() Group d By k=d("Country").toString.Trim Into grp = Group Let sum = grp.sum(function(x) If(IsNumeric(x("Rating").ToString.Trim),CDBL(x("Rating").ToString.Trim),0)) Let ra = New Object(){k,sum} Select r = Newdt.Rows.Add(ra)).CopyToDataTable() cheers

---

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.