Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 August 2024

Top 3 Topics with Most Views

How to get the particular table values and store it into another datatable made by @jamuna_T with 19 views.

How can i optimize the if condition as post 15 or more condition sometime it works and somitime not made by @mint with 18 views.

Object reference error in in_Config made by @Jeeru_venkat_Rao with 15 views.

Top 3 Topics with Most Replies

How can i optimize the if condition as post 15 or more condition sometime it works and somitime not made by @mint with 21 replies.

How to get the particular table values and store it into another datatable made by @jamuna_T with 11 replies.

Object reference error in in_Config made by @Jeeru_venkat_Rao with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 26 posts!

@Anil_G made 18 posts!

@lrtetala made 17 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 1 likes!

Unable to install package / run automation

@JavXult, Normally the dependency packages gets download automatically to user Nuget folder but check it once if it’s there. You can manually try to copy this package to Nuget folders from your development machine. Thanks, Ashok

This post made by @ppr received 1 likes!

Use skip() and Take() method in linq

we suggest to open a new topic on your case and get individually help Preview: Assign Activity: TableList | DataType: List(of DataTable) = dtDataVar.AsEnumerable.Chunk(SegmentSizeAsIntVar).Select(Function (x) x.CopyToDataTable).ToList UPD1 - added preview on calculation of Fixed, Remaining rest Skip Take calculations: [The image shows a debugging session in Visual Studio Immediate Window, displaying the values and computations for , , , , and . (Captioned by AI)]

This post made by @lrtetala received 1 likes!

Get latest and earliest date from column

Hi @SorenB earliestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Min().ToString("dd-MM-yyyy") latestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Max().ToString("dd-MM-yyyy") Regards,

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Get latest and earliest date from column

Hi @SorenB earliestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Min().ToString("dd-MM-yyyy") latestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Max().ToString("dd-MM-yyyy") Regards,

This solution provided by @SorenB received 1 likes!

Unable to install package / run automation

Hello @JavXult Can you please try and compare this file from your development machine, with the one on your production machine? C:\Program Files\UiPath\Studio\NuGet.config If the 2 files differ, then please try this: Take a backup of the file on your production machine Replace the file on your production machine with the file from your development machine Please let me know if it helps. I have created a case at UiPath Customer Support about this NuGet.config file that doesn’t get update…

This solution provided by @lrtetala received 1 likes!

Regex in if statement

Hi @nmjvk Try this For Each item In textArr If System.Text.RegularExpressions.Regex.IsMatch(item, "CVR") Then ' If "CVR" exists in the current item Else ' If "CVR" does not exist in the current item End If Next Regards,

---

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.