Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 November 2023

Top 3 Topics with Most Views

Regex result showing null values made by @chandrakala.productanalys with 62 views.

Unable to create UiPath Support request made by @sowjanya.s with 52 views.

Transaction status remain "In Progress" made by @ch460960 with 48 views.

Top 3 Topics with Most Replies

Regex result showing null values made by @chandrakala.productanalys with 28 replies.

Sentence between two words made by @sshitol with 22 replies.

Is there any other activity other than click or click image made by @harika_k with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 64 posts!

@Yoichi made 27 posts!

@postwick made 26 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

Index was out of the bounds of array: comes when I replace extraction results

@sharon.palawandram , Checking it out from our end we do get value when the index and the value is present : [image] When the Values for the field are missing, then we do not have any values to index to. [image] Also, Maybe a check with the below post : Additionally on handling of missing values : io_ExtractionResults.ResultsDocument.Fields.FirstOrDefault(Function(i As ResultsDataPoint) i.FieldName = "Field Name" AndAlso Not(i.IsMissing)) is Nothing [image] We can then access the Value…

This post made by @nikhil.girish received 2 likes!

Join our Community Quiz to challenge your automation knowledge and win prizes🏆

Congratulations to all the winners , Thanks @loredana_ifrim and @mukeshkala for the initiative

This post made by @pere received 1 likes!

Invoke Powershell is not working

Thanks a lot for helping, @loginerror . At least this gives hope and helps me putting my current work on hold and switch to another task in the meantime. I’ve also had a meeting with your support staff, so they have taken a deeper, like look into the problems I’m experiencing and we are keeping in touch in the hopes they can provide a sort of solution in the following days. I really appreciate your efforts and I understand this sort of things may happen, but it’s good to know that you are takin…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to split an Excel sheet into two individual workbook based on whether it contains specific strings?

Hi, can you try the following sample? [image] dict = dt.AsEnumerable.GroupBy(Function(r) r("School").ToString).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable) Sample Sample20230927-7Lv2.zip (9.4 KB) Regards,

This solution provided by @lrtetala received 1 likes!

Allocating license to Action Center in Community Edition

Hi @krishbcd The following topic might be helps you Cheers!!

This solution provided by @Shiva_Nikhil received 1 likes!

Delete rows from DT where column1 is same and column2 is empty

@markosc dt.AsEnumerable.GroupBy(Function(r) r(0).ToString).Select(Function(grp) If(grp.Count=1,grp.first(),grp.Where(Function(a) a(1).tostring.Trim<>“”).first())).copytodatatable use this [image]

---

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.