Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 June 2023

Top 3 Topics with Most Views

Remove 3 lines from txt document made by @vfaundez with 40 views.

How to calculate the Years and Months and Days in Date made by @404_Error with 29 views.

How to stop the bot if a text doesn't exist made by @raju_alakuntla with 29 views.

Top 3 Topics with Most Replies

Uipath create single status report using 3 Bot made by @Shivam_Rana with 12 replies.

Excelファイルの保存に関して made by @Shige2018 with 10 replies.

Excel activities query made by @Suthari_RohithReddy with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@Yoichi made 14 posts!

@Nitya1 made 11 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 1 likes!

Uipath create single status report using 3 Bot

@Shivam_Rana 1)Make a work flow call this workflow at End process. 2)Make an bool asset and init it with True value. 3) inside work flow get asset value. 4) put if condition and check asset value is True 5) If True then first update asset value as False (So that no other robot will not use this in case of false) 6) now get all files from folder. 7) merge one by one and move in “Processed” folder.( moving will helpful to avoid duplicates in next run) 8) after merge/collate make new in se…

This post made by @Anil_G received 1 likes!

Uipath create single status report using 3 Bot

@Shivam_Rana two options Create a bot to get all status reports and merge and send update the status of all the bots to the queue only in output fields of the queue and create a process to get queue items and create a status report as needed instead of creating individual status reports cheers

This post made by @Anil_G received 1 likes!

How to use queue by Using 3 Bot on a single flow

@Shivam_Rana My bad it should be dt.AsEnumerable.Skip(assetcount).Take(100).CopyToDataTable Missed .AsEnumerable Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Get only one value from cell from datatable

Hi, How about the following? [image] Sample20230603-1aL.zip (11.7 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Lookup Value in DT and delete all the rows

@Sathish_Kumar_S Use find/Replace activity and search for Cancellations… This would give the cell value as output now use delete rows activity with specific rows option and give the rows like this System.Text.RegularExpressions.Regex.Match(cellvalue,"\d+").Value + "-" + (Excel.sheet("Sheetname").RowCount+1).ToString If in datatable please try this dt.AsEnumerable.Take(dt.Rows.IndexOf(dt.AsEnumerable.Where(function(x) x(0).ToString.Contains("Cancellations"))(0))-1).CopyToDataTable cheers

---

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.