Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 September 2021

Top 3 Topics with Most Views

Email cant be send made by @KANG_JEFF_YONG with 35 views.

Why write different between RegEx in UIPath and in web regex online? made by @Maria99 with 34 views.

I can not find Connector.Twitter.Activities package on Package Manage made by @Abdullah_Davut_Demirbilek with 33 views.

Top 3 Topics with Most Replies

Email cant be send made by @KANG_JEFF_YONG with 17 replies.

How to lookup two data tables? made by @aishwarya1 with 8 replies.

How to set up Send Hotkey to go to the next tab of my web navigator? made by @kaiji_San with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 16 posts!

@Srini84 made 12 posts!

@NIVED_NAMBIAR made 10 posts!

Top 3 Most Liked Posts

This post made by @NIVED_NAMBIAR received 3 likes!

How to lookup two data tables?

Hi @aishwarya1 u can try this assume dt1 —> sheet1 dt2 -----> sheet2 dt3_uncommon= (From r1 in dt2.AsEnumerable Where dt1.AsEnumerable().Where(Function(row) row(“Organization Name”).ToString.Trim.Equals(r1(“Organization Name”).ToString)).Count=0 Select r1).CopyToDataTable Now use append range or merge datatable to merge the dt1 and dt3_uncommon to a excel sheet. Regards, Nived N

This post made by @Srini84 received 2 likes!

How to append string variable value to excel file?

@greenlee Check below for your reference Reference Hope this may help you Thanks

This post made by @AshwinS2 received 2 likes!

Click Button, Close Windows, Close Application on Excel file closes other Excel files

Hi @Shinjid Have you tried kill process? Thanks Ashwin.S

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

How to lookup two data tables?

Hi @aishwarya1 u can try this assume dt1 —> sheet1 dt2 -----> sheet2 dt3_uncommon= (From r1 in dt2.AsEnumerable Where dt1.AsEnumerable().Where(Function(row) row(“Organization Name”).ToString.Trim.Equals(r1(“Organization Name”).ToString)).Count=0 Select r1).CopyToDataTable Now use append range or merge datatable to merge the dt1 and dt3_uncommon to a excel sheet. Regards, Nived N

This solution provided by @Srini84 received 2 likes!

How to append string variable value to excel file?

@greenlee Check below for your reference Reference Hope this may help you Thanks

This solution provided by @ppr received 2 likes!

Why write different between RegEx in UIPath and in web regex online?

give a try on regexstorm .NET Regex Tester - Regex Storm more close to .Net

---

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.