Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 July 2021

Top 3 Topics with Most Views

Excel Discrepancy-URGENT made by @mitul_choudhary with 106 views.

Terminal Window Maximize made by @supu123 with 79 views.

Issue with date format from csv to excel made by @Soudios with 54 views.

Top 3 Topics with Most Replies

Issue with date format from csv to excel made by @Soudios with 25 replies.

Excel Discrepancy-URGENT made by @mitul_choudhary with 21 replies.

データテーブルをフィルターアクティビティの不思議な現象について made by @111860 with 20 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 31 posts!

@kumar.varun2 made 25 posts!

@Nithinkrishna made 25 posts!

Top 3 Most Liked Posts

This post made by @dacostri received 3 likes!

Excel Automation-Urgent

I agree with this kind of response. Too many community members are simply asking questions without actually searching for an answer.

This post made by @Yoichi received 3 likes!

Grouping data and add comma

Hi, Hope the following helps you. [img20210715-5] dtResult = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("ID").ToString,r("Code").ToString,r("Usage").ToString,r("Plant Code").ToString,r("Header text").ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.key.item1,g.Key.item2,g.Key.item3,g.Key.item4,g.Key.item5,String.Join(",",g.Select(Function(r) r("doc_number").ToString)) },False)).CopyToDataTable Regards,

This post made by @Ishmeet_Bindra received 2 likes!

UiPath Cloud Masters

Yes Surya, it will be explained!

Top 3 Most Liked Solutions

This solution provided by @StefanSchnell received 2 likes!

Sap easy access issue

Hello Jack, these are different themes, the upper is the Quartz theme and the lower is the SAP Signature theme. Here an example of the differences of the UI elements of the screen 100 of the report SAPLSMTR_NAVIGATION: SAPLSMTR_NAVIGATION_100.zip (1.5 KB) As you wrote, many buttons are missing from Signature to Quartz. This is not an overlay. Check it and configure it at the beginning of your automation workflow which theme to use. Here an example how to check the using SAP theme with an Invo…

This solution provided by @Nithinkrishna received 2 likes!

What us the purpose of 'reset transaction" in edit queue item?

@Elya @ermanoj3101 Reset transaction progress - Let’s say you are retrying a failed item and it comes as New right. But we may not need the old progress messages but just to start fresh. So resetting will be the option to go for. Thanks #nK

This solution provided by @ermanoj3101 received 1 likes!

Excel Automation-Urgent

Hi @mitul_choudhary , You can use below code. I have attached output of this code. test.xaml (10.1 KB) Test.xlsx (7.2 KB)

---

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.