Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 February 2023

Top 3 Topics with Most Views

Assign rows in specific column with For Each Row made by @Steyn_Muller with 110 views.

Testing the new triggered attended automation capabilities with Studio 23.2 made by @bogdanripa with 45 views.

Validation Check is taking too long made by @Md_Asfaque with 44 views.

Top 3 Topics with Most Replies

How to capture the first search link from browser made by @Neha_Aggarwal1 with 15 replies.

Instead of throwing what other activities to be used made by @Mark_Rajkumar with 14 replies.

How to get last row cell value in particular column made by @Raja.G with 12 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 38 posts!

@Sudharsan_Ka made 29 posts!

@fernando_zuluaga made 23 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 3 likes!

Identify if there is any duplicate values in excel column

Hii @nir.kail , Can you please crosscheck which DataTable Variable you have put in the Log message. I think by mistake u have put the Input DataTable I guess .Because if you use the below query DT_Output :- ( From row In DT_Input.AsEnumerable Group row By a=row(“MESSAGE NUMBER”).ToString.Trim Into grp=Group Select grp.First ).CopyToDataTable You should be able to get the required output which we are getting. If not I have dropped the Xaml please try to run that and let us know i…

This post made by @Bilal_Anwar received 2 likes!

Women in Automation Program 2023

That is a good initiative.

This post made by @raduc received 2 likes!

SAP: selector 'tableCol' no longer working

Hi @loxyms, In SAP there are 2 types of tables, grids and tables, and they look very similar but are totally different controls. For grids we generate and use selectors using colName and tableRow and for tables tableRow and colTooltip (but you can also use tableCol here). From your selectors it seems that you are indicating in a grid. To be 100% sure and on the same page, could you please indicate a cell in the table/grid using UiExplorer with the full selector visible? Please be sure to als…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

HELP!. I'm trying to split 1 text file into multiple text files

Hi, Can you try the following sample? [image] arrStr = System.Text.RegularExpressions.Regex.Split(strData,"(?=^10/20)",System.Text.RegularExpressions.RegexOptions.Multiline).Where(Function(s) not String.IsNullOrEmpty(s)).ToArray Sample20230228-3L.zip (2.7 KB) Regards,

This solution provided by @Sudharsan_Ka received 2 likes!

Comparing_Dates

@Hardik_Durgam Checkout this Sequence2.xaml (6.8 KB) In here date_2 in the expression is the one where you need to give your second date variable and it should be in String Regards Sudharsan

This solution provided by @Yoichi received 1 likes!

How to count the values in a column 1 based on column 2 and transpose row to column

Hi, Can you try the following sample? [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Department").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Count,g.Key},False)).CopyToDataTable Sample20230228-1L.zip (10.1 KB) Regards,

[Previous Month] Top 3 Users with the most likes on their solutions

@Anil_G received 65 likes for their solutions!

@Yoichi received 43 likes for their solutions!

@supermanPunch received 34 likes for their solutions!

---

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.