Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 June 2024

Top 3 Topics with Most Views

Deleting of rows for columns such as Time In, Employee, Occupation, Code Number, Department, and Favorite Food made by @RobertRussell_Monsalud with 41 views.

How to check the number of strings that match a format in a certain column of a DATATABLE without using loops? made by @rockchord with 39 views.

Error in getting output dictionary from Queue item made by @shashank with 39 views.

Top 3 Topics with Most Replies

Error in getting output dictionary from Queue item made by @shashank with 13 replies.

Creating a Pivot Table where column names such as Occupation, Amount, Status, and Reference Number are selected made by @RobertRussell_Monsalud with 10 replies.

Transferring of columns such as Time In, Employee, Occupation, Code Number, Department, and Favorite Food made by @RobertRussell_Monsalud with 7 replies.

Top 3 Users Who Posted The Most

@RobertRussell_Monsalud made 18 posts!

@vrdabberu made 18 posts!

@ashokkarale made 14 posts!

Top 3 Most Liked Posts

This post made by @pravallikapaluri received 2 likes!

In filter activity, starts with is not working

Hi @anjani_priya Go to Manage Packages,Update the dependency of Excel activities to the higher version and make runtime rule as lowest to applicable version and save. [image] After that use Excel activities->FilterIt works for me [image] Hope it helps!!

This post made by @RobertRussell_Monsalud received 2 likes!

How to write a datatable using Modern Excel Activities?

Thank you so much @Parvathy @ashokkarale

This post made by @RobertRussell_Monsalud received 2 likes!

Transferring of columns such as Time In, Employee, Occupation, Code Number, Department, and Favorite Food

Hi @vrdabberu I already marked it as a solution. Thank you so much. I really appreciate it. Best regards, Robert

Top 3 Most Liked Solutions

This solution provided by @pravallikapaluri received 2 likes!

In filter activity, starts with is not working

Hi @anjani_priya Go to Manage Packages,Update the dependency of Excel activities to the higher version and make runtime rule as lowest to applicable version and save. [image] After that use Excel activities->FilterIt works for me [image] Hope it helps!!

This solution provided by @vrdabberu received 1 likes!

Deleting of rows for columns such as Time In, Employee, Occupation, Code Number, Department, and Favorite Food

Hi @RobertRussell_Monsalud Check the below workflow: [image] Sequence16.xaml (11.6 KB) Regards

This solution provided by @vrdabberu received 1 likes!

Transferring of columns such as Time In, Employee, Occupation, Code Number, Department, and Favorite Food

Hi @RobertRussell_Monsalud => Read Range Workbook Output → dtSheet1 => Use below syntax in Assign: dtSheet2 = dtSheet1.AsEnumerable().Where(Function(row) DateTime.Parse(row("Time In").ToString()) >= DateTime.Parse("07/27/2022 4:01:00 PM")).CopyToDataTable() => Write Range Workbook dtSheet2 back to excel. 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.