Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 June 2021

Top 3 Topics with Most Views

📢 Announcing UiPath HyperHack - #AutomationForGood Winners! made by @Vibhor.Shrivastava with 371 views.

Uipath Devcon made by @Manikandan_Ckj with 33 views.

Team Lease - Uipath Development and support - Pan India - India - Full Time made by @Manikandan_Ckj with 31 views.

Top 3 Topics with Most Replies

Error : String was not recognized as a valid DateTime made by @Vrushali_Gave with 13 replies.

記入したいRangeの設定方法について made by @Carmen_F with 13 replies.

Dynamic sheet name in excel formula made by @acdeleon123 with 9 replies.

Top 3 Users Who Posted The Most

@postwick made 32 posts!

@Yoichi made 23 posts!

@prasath17 made 11 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 13 likes!

Announcing UiPath HyperHack - #AutomationForGood Winners!

[A4G 3] And here we are, as every great contest reaps glory on its finish line! We embarked on this grand journey with over 350 participants on board for the 2021 UiPath HyperHack – Automation For Good! After kicking off this event in mid-April, with 10 finalists presenting in a live pitching round on June 2nd, now we’ve reached the much-awaited moment of the winners’ announcement! 2 phases and an impressive judging round later, our ‘best for good’ developers have been announce…

This post made by @ppr received 4 likes!

Compare tables based on more than one column using LINQ?

do some preperations for the target structures: Clone dt1 and add the status datacolumn to the dtReportTMPL Clone for dtOut1/2 [grafik] First LINQ: (From d1 In dt1.AsEnumerable Group Join d2 In dt2.AsEnumerable On d1("PLCNO").toString Equals d2("PLCNO").toString And d1("DDNO").toString Equals d2("DDNO").toString And d1("EML").toString Equals d2("EML").toString Into gj = Group From g In gj.DefaultIfEmpty Let status = If(isNothing(g), Nothing, g("STATUS")) Let ra = d1.ItemArray.Append(statu…

This post made by @Manikandan_Ckj received 3 likes!

Reframwork concepts

Uipath Reframework concepts Robotic Enterprise Framework is a project template based on State Machines . It is created to fit all of the best practices regarding logging, exception handling, application initialization, and others, being ready to tackle a complex business scenario. Total 4 States, Initialization Get transaction Process Transaction End Process What is Initialization? Initialization all project relevant details in config file. (Ex: Asset, Folder path, excel sheet name, queue …

Top 3 Most Liked Solutions

This solution provided by @ppr received 4 likes!

Compare tables based on more than one column using LINQ?

do some preperations for the target structures: Clone dt1 and add the status datacolumn to the dtReportTMPL Clone for dtOut1/2 [grafik] First LINQ: (From d1 In dt1.AsEnumerable Group Join d2 In dt2.AsEnumerable On d1("PLCNO").toString Equals d2("PLCNO").toString And d1("DDNO").toString Equals d2("DDNO").toString And d1("EML").toString Equals d2("EML").toString Into gj = Group From g In gj.DefaultIfEmpty Let status = If(isNothing(g), Nothing, g("STATUS")) Let ra = d1.ItemArray.Append(statu…

This solution provided by @prasath_S received 2 likes!

Read row until row blank

Hi @fairymemay Please try this dtTable.AsEnumerable.TakeWhile(Function(row) row.ItemArray.Any(function(col) not string.IsNullOrEmpty(col.ToString))).CopyToDataTable [image] [image] Thanks

This solution provided by @balupad14 received 1 likes!

How can i delete sheet in Excel

Thank you @Soudios. I think the problem solved now…

---

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.