Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 January 2024

Top 3 Topics with Most Views

What is Studio doing made by @Dion with 71 views.

Combine 2 read range PLEASE HELP! made by @flashdrive07 with 45 views.

Get data in excel sheet and write it to another sheet made by @KSK_R_D with 43 views.

Top 3 Topics with Most Replies

What is Studio doing made by @Dion with 19 replies.

Regex split text made by @Demo_User with 12 replies.

Getting invocation error for false statement made by @dipon1112000 with 12 replies.

Top 3 Users Who Posted The Most

@mkankatala made 38 posts!

@vrdabberu made 24 posts!

@postwick made 19 posts!

Top 3 Most Liked Posts

This post made by @pikorpa received 3 likes!

Run query activity error

Hey @fairymemay If I remember correctly Oracle is using the single quotes in string, so it can be cause of your issue. Try it: "Select a.extract_date, a.due_date ""Due_Date"", c.l9_company_code ""Company_Code"", COUNT(*) ""BCV_Transaction"", SUM(a.actual_amount) ""BCV_Amount"", (Case When c.l9_company_code = 'RF' THEN 'RF' When c.l9_company_code = 'RM' THEN 'RF' When c.l9_company_code = 'TS' THEN 'RF' When c.l9_company_code = 'TI' THEN…

This post made by @suchismita648 received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone! I am Suchismita . I want to build my career as an RPA developer which leads me to choose UiPath professional certification exams.And through that academy journey I found some difficulties on solving data manipulation questions and then i redirected to forum. From that episode I am here. Thank you!

This post made by @Parvathy received 1 likes!

Convert String taken from DataTable to DateTime Variable

Hi @tommaso.perina Could you share the Excel with sample data. I think you are getting the date into an variable said strAssignmentDate so it should not passed within double quotes. DateTime.ParseExact(strAssignmentDate.ToString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)’ to ‘dtimeAssignmentDate Regards

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 3 likes!

Run query activity error

Hey @fairymemay If I remember correctly Oracle is using the single quotes in string, so it can be cause of your issue. Try it: "Select a.extract_date, a.due_date ""Due_Date"", c.l9_company_code ""Company_Code"", COUNT(*) ""BCV_Transaction"", SUM(a.actual_amount) ""BCV_Amount"", (Case When c.l9_company_code = 'RF' THEN 'RF' When c.l9_company_code = 'RM' THEN 'RF' When c.l9_company_code = 'TS' THEN 'RF' When c.l9_company_code = 'TI' THEN…

This solution provided by @Anas-p-v received 1 likes!

Get data in excel sheet and write it to another sheet

Use filter data table activity from activity panel, provide the table to be filtered and the condition (column which to be checked for non empty values). Attaching screenshot below for reference. [image]

This solution provided by @mkankatala received 1 likes!

Getting error API_test.xaml: BC30574: Option Strict On disallows late binding

Hi @Dinesh5 You can click on Type argument option in properties and click on Browse For Types and type JObject in the Type Name field. [image] [image] Then, you could create a new variable in the Output Property so that you get the JObject type output. Hope it helps!!

---

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.