Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 November 2023

Top 3 Topics with Most Views

How to get the value in the particular cell dynamically made by @anjani_priya with 50 views.

Automation with notepad file made by @JITU99 with 48 views.

Invoke Code to read excel - VB Net error made by @Ana_Patricia with 43 views.

Top 3 Topics with Most Replies

How to get the value in the particular cell dynamically made by @anjani_priya with 32 replies.

How to solve the error that column doesn't exist made by @anjani_priya with 19 replies.

Error (Assign: The source contains no DataRows) made by @Lee4216 with 17 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 41 posts!

@sanjay3 made 28 posts!

@rikulsilva made 26 posts!

Top 3 Most Liked Posts

This post made by @rikulsilva received 2 likes!

Cannot find the excel file in test environment while i can see the bot is saving the file in dev environment

in this case, the Excel file is not been saving in your test environment. Are you running you bot from orchestrator ? I totally agree with @AJ_Ask, it much better you define a common location for your files that is equal for all your environment or you can change it from asset, for example But if you want to do more troubleshooting, you can add the Write Range activity inside a Try Catch activity and in Catches block, you add log to see with something going wrong when bot is saving the Excel …

This post made by @Josefina_Belgrave received 1 likes!

Automation Business Analyst Series 2023

Unfortunately, I am still not able to upload my completed training certificates, So I am posting them here.

This post made by @matt.theisen received 1 likes!

Complex Filter for Directory Files

Saw this question here but unfortunately nobody was able to provide a good solution and I was not able to respond to the question with an alternative solution. My suggestion is to use a regular expresion (regex) - you can test your regex here. Regex can be a bit confusing at first but it is a great skill to learn. This code also uses Linq (the part of the code which says .Where(…)) which is a very powerful method of doing inline code. The structure in the package would go as follows: 1. Assig…

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Equal & not equal with LINQ

Hi @anh.nguyen Try this: (From d1 In dtARR13.AsEnumerable() Let lid = d1(0).ToString().Trim() Where dtDeposit.AsEnumerable().Any(Function(d2) d2(0).ToString().Trim().Equals(lid)) AndAlso Not dtSum.AsEnumerable().Any(Function(d3) d3(0).ToString().Trim().Equals(lid)) Select r = d1).ToList() Hope it helps!!

This solution provided by @nikhil.girish received 1 likes!

Run performer without using orchestrator

Hi @Vincent2 Since you are not going with orchestrator One method I can recommend is to use invoke process within the dispatcher, so tht it would trigger performer

This solution provided by @nikhil.girish received 1 likes!

Not able to access Associate course

Hi @Rishab2 Check this out

---

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.