Forum Engagement Daily Reports

[system]

Daily Forum Report | 17 February 2022

Top 3 Topics with Most Views

Deserialze Jason for particular value made by @Sahil_Garg1 with 47 views.

How to iterate over Columns and only one row made by @Doonline with 43 views.

ADD SERAIL NUMBER (S/N) INTO A DATATABLE made by @Ahmad_Rais with 42 views.

Top 3 Topics with Most Replies

ADD SERAIL NUMBER (S/N) INTO A DATATABLE made by @Ahmad_Rais with 22 replies.

Deserialze Jason for particular value made by @Sahil_Garg1 with 20 replies.

How to update specific values in datatable without using for each row made by @111962 with 12 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 31 posts!

@ppr made 24 posts!

@Gokul001 made 24 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

How to get single value from datatable using Linq

dtData.AsEnumerable().Where(function(x) x("EmpID").toString.Trim.Equals("12345")).Select(Function (x) x("Age").FirstOrDefault handling not found case We do not use CoptToDataTable when we can expect also an empty filter result. In such case CopyToDataTable will throw an exception. FirstOrDefault will return null in the case no matching row was found

This post made by @Srini84 received 2 likes!

How to Pick Some Columns for Data Scraping

@Archie Once the data scraping is done then it will store into the datatable So you can use Filter Datatable and give which columns you need as below [image] Hope this will help you Thanks

This post made by @Gokul001 received 2 likes!

How to Pick Some Columns for Data Scraping

HI @Archie You can achieve this by two methods as far i know Method 1 While Data scrapping the table the wizard will be shown that can it get all the values from table In that you need to select the NO and select the columns manually and give your column name and extract correlated data of all column you need. Method 2 After datascrapping the table Use Filter datatable and Go to Output column section and click on Keep radio button and give your column names one by one by clicking “+” on i…

Top 3 Most Liked Solutions

This solution provided by @ppr received 4 likes!

How to get single value from datatable using Linq

dtData.AsEnumerable().Where(function(x) x("EmpID").toString.Trim.Equals("12345")).Select(Function (x) x("Age").FirstOrDefault handling not found case We do not use CoptToDataTable when we can expect also an empty filter result. In such case CopyToDataTable will throw an exception. FirstOrDefault will return null in the case no matching row was found

This solution provided by @Gokul001 received 2 likes!

How to Pick Some Columns for Data Scraping

HI @Archie You can achieve this by two methods as far i know Method 1 While Data scrapping the table the wizard will be shown that can it get all the values from table In that you need to select the NO and select the columns manually and give your column name and extract correlated data of all column you need. Method 2 After datascrapping the table Use Filter datatable and Go to Output column section and click on Keep radio button and give your column names one by one by clicking “+” on i…

This solution provided by @pravin_calvin received 2 likes!

Bot is not performing as expected from the Orchestrator

Hi @md.musaalireza Is the output file is in same project folder? If yes then try changing the output file apart from the project folder! 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.