Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 January 2023

Top 3 Topics with Most Views

Click Dynamic dropdown item made by @nagsai with 48 views.

How to iterate over all columns of an excel sheet and change colour of specific cells made by @nmjvk with 44 views.

Extract a number from string made by @pravin_bindage with 44 views.

Top 3 Topics with Most Replies

Selector stability made by @Mark_Rajkumar with 21 replies.

Send dynamic email attachement made by @rayz1503 with 21 replies.

Headers are not Shown when copy Table made by @firas with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 59 posts!

@Sudharsan_Ka made 45 posts!

@Yoichi made 33 posts!

Top 3 Most Liked Posts

This post made by @Gnanapriya_G received 4 likes!

How to merge two arrays - month and year

Hi @gischethans, What about this arrYer = {“2022”, “2023”} arrMon = {“Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”, “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”} (From x in arrYer From y in arrMon Let z=x+"-"+y Select(z)).ToArray() Thanks,

This post made by @Anil_G received 2 likes!

Filtering Datatable Using Array of String

@benjiherb Please try with linq query as below dt.AsEnumerable.Where(function(x) arr.Any(function(y) x("ColumnA").ToString.Contains(y))).CopyToDatatable dt is the datatble arr is the array containing your strings cheers

This post made by @jeffsilva received 1 likes!

Database Connect Activity Broken when Migrating to Windows activity

Hi Maciej, Good guess on the driver, for me it was that the issue. Never thought of checking the version because we have been using the 32 bit with legacy and it was setup a long time ago. Did this just happen to be the case with this activity set (UiPath.Database) or are generally all newer activities Net5+ using 64 bits as a default? Just curious. @taxguy33 I have mine setup on the System, however I use the Oracle Client 19c at the machine level. Might not be your setup. Oracle Database 19c…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Filtering Datatable Using Array of String

@benjiherb Please try with linq query as below dt.AsEnumerable.Where(function(x) arr.Any(function(y) x("ColumnA").ToString.Contains(y))).CopyToDatatable dt is the datatble arr is the array containing your strings cheers

This solution provided by @mahmoud.zaky received 1 likes!

Reframework question

you welcome any time and the right choose is C and i added clarification in below screen hope its help you [image]

This solution provided by @allbran received 1 likes!

データテーブル上の値の変数による指定方法

@HANACCHI 使っている箇所とでスコープが違っている まさしくこれでした。まだUiPath歴が浅いもので何も考えずに宣言したスコープが間違っていたようです。

---

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.