Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 November 2021

Top 3 Topics with Most Views

How can I filter a csv with a specific date format string for rows where the date is newer then a given date X? made by @GeraltDieSocke with 33 views.

How to Delete Chrome history without opening Chrome Application made by @shreyash_shirbhate with 32 views.

Unexpected error occurred 500 made by @Gokul001 with 31 views.

Top 3 Topics with Most Replies

How to Delete Chrome history without opening Chrome Application made by @shreyash_shirbhate with 21 replies.

パソコン起動時にUiPathプログラムを実行したいです。 made by @miwa_yamamoto with 19 replies.

Type into activity not working in a particular text box made by @mukul_singh with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 46 posts!

@kirankumar.mahanthi1 made 36 posts!

@Yoichi made 29 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

How to kill a process for current user with one line power shell code

SCENARIO KILL PROCESS - plays a major role in all the enterprise level workflows especially with the process built using REFramework template, where we have a separate workflow either to kill all the open application. It’s well known for everyone that a simple kill process will close all the application by mentioning those application exe file name in PROCESSNAME property. But what if your bot is running in a concurrent runtime machine where multiple user will be running bot at the same, May …

This post made by @Dawodm received 2 likes!

LINQ - LINQ Group - LINQ IF - LINQ Let - LINQ Join

Do you want to use LINQ in your process and you have to idea, how to learn it? Here are some videos, where you can learn the most used functions in LINQ. LINQ Training: UiPath | LINQ Training | Learn LINQ for UiPath from A to Z | LINQ Query Structure | LINQ Query Parts - YouTube LINQ Group Function: UiPath | LINQ Group Function | Get Unique Rows from DataTable | Duplicate Rows | Not Duplicate Rows - YouTube LINQ Let Function: UiPath | LINQ Let Function | Calculate variable in LINQ | Calculat…

This post made by @Yoichi received 2 likes!

Is there an efficient way to get all the duplicate rows from the Datatable and then delete them without using for each?

Hi, Can you try the following expression? dtB=dtA.AsEnumerable.GroupBy(Function(r) r("value1").ToString).Where(Function(g) g.Count=1).SelectMany(Function(g) g).CopyToDataTable() dtC=dtA.AsEnumerable.GroupBy(Function(r) r("value1").ToString).Where(Function(g) g.Count>1).SelectMany(Function(g) g).CopyToDataTable() Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Is there an efficient way to get all the duplicate rows from the Datatable and then delete them without using for each?

Hi, Can you try the following expression? dtB=dtA.AsEnumerable.GroupBy(Function(r) r("value1").ToString).Where(Function(g) g.Count=1).SelectMany(Function(g) g).CopyToDataTable() dtC=dtA.AsEnumerable.GroupBy(Function(r) r("value1").ToString).Where(Function(g) g.Count>1).SelectMany(Function(g) g).CopyToDataTable() Regards,

This solution provided by @90sDeveloper received 1 likes!

Reading text after hover

Hi @Mahalakshmi, Try this workflow which works for all the Twitter accounts where the followers should be in million like(1M, 1.4M). Hope it solves your query. @TwitterFollowersCountv2.xaml (9.3 KB) Regards, @90sDeveloper

This solution provided by @Yoichi received 1 likes!

現在の処理行数を取得したい

こんにちは ForEachRow内での行番号を取得したいのであれば ForEachRowのIndexプロパティに変数を設定すると、 自動的に現在の行番号がセットされます。 （上記の場合、そこに 現在の行番号 をセットすればOK） またCurrentRowが現在の何行目かを取得したい場合は元のDataTableをdtとすると dt.Rows.IndexOf(CurrentRow) でも取得できます。

---

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.