Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 August 2021

Top 3 Topics with Most Views

I want to click on purple place made by @S_Sim with 41 views.

Cav to excel made by @pari_patel with 39 views.

For each file in each subfolder made by @AdamKA with 34 views.

Top 3 Topics with Most Replies

I want to click on purple place made by @S_Sim with 12 replies.

How to move pdf files from multiple folders having DDMMYYYY format and copy to new location made by @enthusiastic with 11 replies.

Hi, I had got this error while adding queue item made by @bala371 with 11 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 22 posts!

@ppr made 18 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Delete duplicate row if one column contain certain special string

Hi, Hope the following helps you. [img20210820-2] dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Name").ToString,r("Position").ToString)).SelectMany(Function(g) if(g.Key.Item2="Staff",{g.First()},g.Select(Function(r) r))).CopyToDataTable Sample20210820-2.zip (9.5 KB) Regards,

This post made by @jeevith received 3 likes!

Debugging with the orchestrator is frustrating

Hi @kbak, I second that and I feel your pain. After some very frustrating days we decided it was enough. Orchestrator does not help us when we need a hotfix and are stuck with parsing logs to find the needle in the haystack. The search function is great but when we are a small team we need results quick. We use a custom dashboard on Splunk and get all the diagnostic metrics of robot executions, failures and time usage for every process and can slice and dice the data to our liking. I did pen…

This post made by @Tory received 2 likes!

UiPathPlatformInstaller.exeでのインストール時間

Studio.2021.4.3から正式に UiPathStudio.msi が 64 ビット インストーラーになり UiPathPlatformInstaller.exe を廃止するそうです。 参考までに 2021.4.3 (uipath.com)

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Delete duplicate row if one column contain certain special string

Hi, Hope the following helps you. [img20210820-2] dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Name").ToString,r("Position").ToString)).SelectMany(Function(g) if(g.Key.Item2="Staff",{g.First()},g.Select(Function(r) r))).CopyToDataTable Sample20210820-2.zip (9.5 KB) Regards,

This solution provided by @kumar.varun2 received 2 likes!

Cav to excel

@pari_patel Give it a try [image]

This solution provided by @prasath17 received 2 likes!

I am not able to filter on date in a data table

@manjesh_kumar - Please look closely… CDate(row(“Grn Date”)).Date. Equals (now.Date)) In the above code, you are checking the Grn Date is equals to Now.date…i believe none of the values in the sheet has the 08/20 date so it is returning the count to 0. CDate(row(“Grn Date”)).Date > now.Date) Note: CDate and Datetime.parse will work based on the local system settings, i.e. my local settings MM/dd/yyyy so if use cdate with dd/MM/yyyy format it will thrown an error. You get it?? Suggestion: B…

---

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.