Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 March 2022

Top 3 Topics with Most Views

string.Contains() not working made by @ainaasyhda with 53 views.

How to get TransactionItem Number? made by @MasterSinge with 48 views.

I need to check if the second variable contains 70% of the first variable made by @ridvanucok with 47 views.

Top 3 Topics with Most Replies

Get Asset - You are not authenticated! Error Code: 0 made by @Craig_Bannerman1 with 20 replies.

Cannot Trigger UiPath Robot after Update to latest UiPath studio version made by @Ashok_kumar7 with 14 replies.

Delete column (error Copytodatable is not a member) made by @fairymemay with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 30 posts!

@ashwin.ashok made 28 posts!

@ushu made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

This post made by @shalini.singh received 2 likes!

Care Health Insurance - RPA Developer - Gurgaon - India - Full Time

Job title: RPA Developer Job role: RPA Developer Country: India City: Gurgaon Company name: Care Health Insurance Employment Type: Full Time Seniority level: Junior 1 to 2 years Job Description: Role Description • Design the automation workflows, write the code using UiPath • Make changes to the robot code during implementation as needed • Responsible for the overall testing cycles Requirements • Graduate in Computer Science/IT or equivalent Degree • Analytical and proven problem-s…

This post made by @Yoichi received 2 likes!

BC20198 ')' expected at Line 1

Hi, FYI, VB expression for it will be the following. in_dt_dsrDtRaw.AsEnumerable().ToList().ForEach(Sub (row) If(row("INVOICE_NUMBER").tostring.substring(0,3)="950") Then row("BILLED_QTY")=0 row("LOCAL_CURR_AMOUNT") = Double.Parse(row("LOCAL_CURR_AMOUNT").ToString) * -1 row("NET_AMOUNT")=Double.Parse(row("NET_AMOUNT").ToString) * -1 End If End Sub )

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

BC20198 ')' expected at Line 1

Hi, FYI, VB expression for it will be the following. in_dt_dsrDtRaw.AsEnumerable().ToList().ForEach(Sub (row) If(row("INVOICE_NUMBER").tostring.substring(0,3)="950") Then row("BILLED_QTY")=0 row("LOCAL_CURR_AMOUNT") = Double.Parse(row("LOCAL_CURR_AMOUNT").ToString) * -1 row("NET_AMOUNT")=Double.Parse(row("NET_AMOUNT").ToString) * -1 End If End Sub )

This solution provided by @ppr received 2 likes!

Get Asset - You are not authenticated! Error Code: 0

[image] [/quote] not sure if an explicit reference to UiPath.Activities.Api is needed. Check its removal also

This solution provided by @Gokul001 received 2 likes!

Edit code LINQ?

Hi @fairymemay Why you need to delete the column? Have a look on the thread Regards Gokul

---

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.