Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 January 2024

Top 3 Topics with Most Views

How to change date format into specific month made by @anjani_priya with 59 views.

Log Message: Column 'HR' does not belong to DataTable(config file) made by @chandrakala.productanalys with 48 views.

Excel-based Run Query stuck made by @Fabio_G_Silva with 46 views.

Top 3 Topics with Most Replies

How to change date format into specific month made by @anjani_priya with 49 replies.

Need to calculate two columns of notepad made by @dipon1112000 with 25 replies.

How to sum three columns in LINQ query made by @sathish_Kumar6 with 22 replies.

Top 3 Users Who Posted The Most

@mkankatala made 54 posts!

@anjani_priya made 34 posts!

@Anil_G made 33 posts!

Top 3 Most Liked Posts

This post made by @vrdabberu received 3 likes!

Unable to process division

Hi @dipon1112000 ] Check out the below workflow: [image] Assuming your input is like below: [image] =>Use Read CSV to red the file and store the output in a datatable. => Use For Each row in DataTable to iterate through each row and give the below syntax in assign activity: Number1= CDbl(CurrentRow("column3").ToString) Number2= CDbl(CurrentRow("Column5").ToString) Note: Number1 and Number2 are of DataType System.Double. => Use WriteLinew to print the values by giving below syntax: (Nu…

This post made by @mkankatala received 2 likes!

Re-framework exception occurs stars

Hi @siva_sankar There is only two exceptions here one is Business Exception and second is System Exception. We don’t have failed exception, if any unknown exception occurs it will consider it as System Exception. If we will discuss about flowing of states. → If the Transaction status is Success it will increment the transaction item and go for the next transaction started from Get transaction item state. → If the Transaction status is Business Exception it will consider the present transa…

This post made by @siva_sankar received 1 likes!

Re-framework exception occurs stars

In this case if system rule expection occurs means or application expection occurs means it will go to the int state right???

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Excel condition value

@wjdehdnr456 Looks like this is a duplicate Cheers

This solution provided by @Yoichi received 1 likes!

Need Help in Excel segregation and Splitting

Hi, I think it’s necessary to clarify your requirement more, for example key etc. However, how about the following? [image] Sample20240101-2.zip (15.0 KB) Regards,

This solution provided by @vrdabberu received 1 likes!

When comparing DT1 and DT2, retrieve the matching rows Help

Hi @22222222asas Try this query: resultDataTable = (From row1 In DT1.AsEnumerable() Join row2 In DT2.AsEnumerable() On row1("NUMBER").ToString() Equals row2("NUMBER").ToString() Select row1).CopyToDataTable() resultDataTable is of DataType System.Data.DataTable If possible share the DT1 and DT2 data tables with dummy data. 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.