Forum Engagement Daily Reports

[system]

Daily Forum Report | 27 August 2021

Top 3 Topics with Most Views

Regex with multiple values text made by @Fernando_Ferrari_Longato with 34 views.

Subtraction of the two columns made by @HeartCatcher with 34 views.

Remove duplicates in DT for specific columns and keep all column and values made by @prabhu_ponnusamy with 26 views.

Top 3 Topics with Most Replies

Subtraction of the two columns made by @HeartCatcher with 20 replies.

Copy Images From Image Path And replace It Into Another Folder made by @Ajit_Chowdary with 14 replies.

ReFramework - Can't get the next transaction item even though it hits a business exception made by @Jayavignesh_G with 13 replies.

Top 3 Users Who Posted The Most

@ppr made 27 posts!

@ermanoj3101 made 22 posts!

@NIVED_NAMBIAR made 16 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

How to Wait for an SAP Background Operation

Sometimes it is necessary to wait for an SAP background operation. This post briefly explains how this can be realized. This is very easy to implement with the sapReadyState attribute in a loop. [image] [image] As we can see here we have a simple do-while loop that is executed as long as the sapReadyState is false. Additionally a delay activity is included to save resources. That’s all. If a timeout is still needed, this can also be inserted quite simply by an if-condition with a break. [i…

This post made by @Anna_Thomas received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, Myself Anna Thomas. I am a student learning BTech CS and am an entrepreneur. I was really fascinated by what UiPath had always offered us and wanted to be a part of it. Really looking forward to learn new things and gain amazing experiences.

This post made by @AIROBOHUB received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Every One, I Ch Srinivasa Rao having 19+ Years of Exp. in IT Industry and last 5+ Years I have been into RPA, and my last designation as employee was “Tech Arch Delivery Manger” in my last company Basically I’m from Hyderabad, Telangana, India

Top 3 Most Liked Solutions

This solution provided by @lakshman received 2 likes!

How to exclude "Null" and "0" and store to Array variable?

@Dorothy_lee Try below expression before converting it to array. Dt_keyword = Dt_keyword.Select("Name <> 'Null' or Name <> '0'").CopyToDataTable

This solution provided by @GreenTea received 2 likes!

How to store data if column name is null?

Hi @Dorothy_lee Please check this thread to add column header. Replace the square brackets to round brackets Or otherwise provide the column index, which starts at 0 instead of column name - Convert.ToString(row.Item(0))

This solution provided by @ppr received 2 likes!

Problems extracting the minimum date from a datatable

@JavXult RegisDT.AsEnumerable().OrderBy(Function (x) Convert.ToDateTime(x(“Date”).toString.Trim)).First() Or RegisDT.AsEnumerable.Min(Function (x) CDate(x(“Date”).toString.Trim)) [grafik] If it is failing, then in often cases the format is not valid / different set breakpoint debug and get paused open immediate panel run analyzer statement: dtData.AsEnumerable.Where(Function (x) Not DateTime.TryParse(x(“Date”).toString.Trim,nothing)).ToList

---

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.