Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 July 2022

Top 3 Topics with Most Views

Read pdf text with regex made by @Chen-Jim with 47 views.

Randomly change/run workflow file after added made by @IPIX with 33 views.

Can UiPath make sub header? made by @Rhys18 with 32 views.

Top 3 Topics with Most Replies

How to send Ctrl+Shift+S to a pdf in Microsoft Edge? made by @kkpatel with 18 replies.

CopyToDataTable is not a member of System.Data.Datatable made by @hurmet.noka with 13 replies.

Message Box Delay and Button Function made by @Amin with 10 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 24 posts!

@Nithinkrishna made 21 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @THIRU_NANI received 2 likes!

UiPath Replace Text (URGENT)

Hey! As @Rahul_Unnikrishnan and @Veera_Raj mentioned you can use Generate data table activity… not text to data table activity You can refer the below video [UiPath- Text to DataTable |Generate DataTable & Text to Columns activities] Regards, NaNi

This post made by @Steven_McKeering received 2 likes!

Cron trigger advanced

Hello @RENAUD_Jean-Christophe I don’t think it’s possible. You can combine a non working days calendar with a cron for the first of each month (see above from @THIRU_NANI) Then take a look here: Another option is this. Add logic to your solution to not run on Mondays? Hopefully this helps. Cheers Steve

This post made by @Alexandru_Szoke received 1 likes!

Orchestrator in Automation Cloud™ - Data Retention and Archiving for QueueItems

Hi @Raghavendraprasad You can set the policy to higher than 30days if that timeframe does not yield a review by SMEs in your cases. Thank you, Alex.

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 2 likes!

Cron trigger advanced

Hello @RENAUD_Jean-Christophe I don’t think it’s possible. You can combine a non working days calendar with a cron for the first of each month (see above from @THIRU_NANI) Then take a look here: Another option is this. Add logic to your solution to not run on Mondays? Hopefully this helps. Cheers Steve

This solution provided by @Yoichi received 1 likes!

Group by data in DataTable

Hi, How about the following? [image] dict = dt.AsEnumerable().GroupBy(Function(r) r("Contact").ToString()).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable) Sample20220725-7.zip (3.0 KB) Regards,

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

CopyToDataTable is not a member of System.Data.Datatable

@hurmet.noka Please refer this xaml. Removing the duplicate based on two columns only. The output will have all the rows. RemoveDuplicateBasedOnTwoColumns.xaml (7.8 KB) [image]

---

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.