Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 October 2024

Top 3 Topics with Most Views

Compare two Datatables(LINQ) made by @rockchord with 21 views.

Automation suggestion using string values made by @Ajith3 with 11 views.

繰り返し(データテーブルかExcelのどちらでも)で画面上をクリックする made by @toshiki_kubo with 10 views.

Top 3 Topics with Most Replies

Compare two Datatables(LINQ) made by @rockchord with 14 replies.

Automation suggestion using string values made by @Ajith3 with 11 replies.

Find Specific File in the Directory and Return The File Name in the Email made by @nirmit.kansagra with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 10 posts!

@rockchord made 8 posts!

@sudster made 8 posts!

Top 3 Most Liked Posts

This post made by @rashmisingh2695 received 1 likes!

Compare two Datatables(LINQ)

Try to use this expression in Invoke code For Each row1 As DataRow In dtInput1.Rows Dim row2 As DataRow = dtInput2.AsEnumerable().Where(Function(r) r("Company").ToString() = row1("Company").ToString()).FirstOrDefault() If row2 IsNot Nothing Then Dim errors As New List(Of String) If row1("Company").ToString() <> row2("Company").ToString() Then errors.Add("Company") If row1("Code").ToString() <> row2("Code").ToString() Then errors.Add("Code"…

This post made by @nirmit.kansagra received 1 likes!

Find Specific File in the Directory and Return The File Name in the Email

Thank you so much this. How do I send an email if my file is not found? I want to send email for both cases if found or if not found. I got the email to be sent with the file name if file is found, but don’t know how to send email if not found.

This post made by @rashmisingh2695 received 1 likes!

Compare two Datatables(LINQ)

Hi @rockchord Please try to use this code in invoke code activity and you should be able to get the output First build the OutputDT with required columns and then use the invoke code For Each row1 As DataRow In dtInput1.Rows Dim row2 As DataRow = dtInput2.AsEnumerable().Where(Function(r) r("ID").ToString() = row1("ID").ToString()).FirstOrDefault() If row2 IsNot Nothing Then Dim errors As New List(Of String) If row1("Company").ToString() <> row2("Com…

Top 3 Most Liked Solutions

This solution provided by @rashmisingh2695 received 1 likes!

Compare two Datatables(LINQ)

Try to use this expression in Invoke code For Each row1 As DataRow In dtInput1.Rows Dim row2 As DataRow = dtInput2.AsEnumerable().Where(Function(r) r("Company").ToString() = row1("Company").ToString()).FirstOrDefault() If row2 IsNot Nothing Then Dim errors As New List(Of String) If row1("Company").ToString() <> row2("Company").ToString() Then errors.Add("Company") If row1("Code").ToString() <> row2("Code").ToString() Then errors.Add("Code"…

---

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.