Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 December 2023

Top 3 Topics with Most Views

製品ドキュメントの人間翻訳版公開のお知らせ (2023 年 11 月 17 日更新確認分) made by @Naoko_Sato with 60 views.

Download File From URL made by @marina.dutta with 56 views.

What's the license difference between Unattended Robot - Test and Non-Production Licenses? made by @jimmy2 with 50 views.

Top 3 Topics with Most Replies

Download File From URL made by @marina.dutta with 14 replies.

Get IMAP Mail Messages: Application-specific password required, sender id's made by @lakshmi.mp with 13 replies.

How to I split the values of an Excel cell to multiple variables based on the character count? made by @uio with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 19 posts!

@Anil_G made 19 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @AJ_Ask received 2 likes!

Merge 3 datatables into one

How to merge more than one datatables using LINQ using Uipath - News / Tutorials - UiPath Community Forum

This post made by @J0ska received 2 likes!

How to manage Null DT so it does not throw NullReferenceException

Hi @Nawazish_Ahmad Better if you delete your advice. The question was how to handle Null DT. Your proposal will not address it → if DT is Null then DT.RowCount will throw exception. Cheers P.S. Even after the update your advice is not any better The correct answer was already given by @Yoichi

This post made by @Nawazish_Ahmad received 1 likes!

Error opening PDF file same as Excel character

Hi @22222222asas You can do this by getting only the unique Number value from F Column to open the PDF only once by looping on each value as Data Table or Array from the below methods (You can choose once according to your requirement) 1 Solution: To get all the unique values of Column Number (Output as Data Table) DT.AsEnumerable.GroupBy(Function (x) x(“Number”).ToString).[Select](Function(y) y.First).CopyToDatatable 2nd Solution: To get all the unique values of Column Number (Output as A…

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Split Datatable with LINQ

when we can assume that doubles are ok e.g. we could do: Assign Activity: Assign Activity iCount | int32 = dtDataVar.AsEnumerable.Select(Function (d) d("NameCol").toString.Trim).Distinct().Count Assign Activity dtTemplate = dtDataVar.Clone Assign Activity dtTemplate = (From d in dtDataVar.AsEnumerable Group d by k=d("NameCol").toString.Trim into grp=Group Let cs = grp.Sum(Function (s) CInt(s("NoColName").toString.Trim)) Let ra = new Object(){k,cs/iCount } Select r = dtTemplate.Rows.Add(…

This solution provided by @Parvathy received 1 likes!

フォルダ内のファイルをすべて削除したいです

Hi @111561 If you have files within a folder then use the below code in Invoke Code activity Dim directoryInfo As New System.IO.DirectoryInfo(folderPath) ' Delete all files in the folder directoryInfo.GetFiles().ToList().ForEach(Sub(file) file.Delete()) If you have sub-folders within a folder then use the below code in Invoke Code activity Dim directoryInfo As New System.IO.DirectoryInfo(folderPath) ' Delete all files in the folder directoryInfo.GetFiles().ToList().ForEach(Sub(file) file.D…

This solution provided by @jack.chan received 1 likes!

Merge 3 datatables into one

@Povilas_Jonikas use merge datatable activity e.g. you have dt1, dt2, dt3 use two merge datatable activities source = dt2 target = dt1 source = dt3 target = dt1 now dt1 contains merged result of dt1,2,3

---

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.