Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 February 2022

Top 3 Topics with Most Views

Dynamic CV table extraction (having cursor) made by @Sonalk with 64 views.

Check data in another file? made by @fairymemay with 60 views.

How to split data table from excel sheet made by @Giriraj_Vishwas_Hande with 53 views.

Top 3 Topics with Most Replies

Need help on making reliable selector for every time made by @shreyash_shirbhate with 21 replies.

Check data in another file? made by @fairymemay with 15 replies.

How to split data table from excel sheet made by @Giriraj_Vishwas_Hande with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@pravin_calvin made 28 posts!

@THIRU_NANI made 21 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

Please help me on regex

Hi @Clinton_Das Try this Regex Expression Use Assign activity LHS - Create an Variable RHS - System.Text.RegularExpressions.Regex.Match(“Input String”,“[A-Za-z]\d+”).Tostring.Trim More information about regex Hope it will work Regards Gokul

This post made by @RPAForEveryone received 2 likes!

Lookup range Multiple column values at a time

Hi @Satish_Ch Please consider using Filter Data Table activity. This link shows information with images, how the Filter activity can be used to include multiple lookup columns using AND and/or OR combinations. [image] I hope this solves your query.

This post made by @gabrielribas4 received 2 likes!

Lookup range Multiple column values at a time

Hey @Satish_Ch!! Try this! Im using this excel as Input. [image] I’m reading this data and storing it in the “dt_input” variable. [image] I will surround my Assign activity with “Try Catch” to simulate the “Lookup DataTable” activity. If no match is found, it returns -1. We first perform a filter on the values ​​to identify the match. [image] ( From p In dt_input.Select() Where p(0).ToString.Equals(val1) and p(1).ToString.Equals(val2) Select p ).CopyToDatatable If there i…

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

Please help me on regex

Hi @Clinton_Das Try this Regex Expression Use Assign activity LHS - Create an Variable RHS - System.Text.RegularExpressions.Regex.Match(“Input String”,“[A-Za-z]\d+”).Tostring.Trim More information about regex Hope it will work Regards Gokul

This solution provided by @gabrielribas4 received 2 likes!

Lookup range Multiple column values at a time

Hey @Satish_Ch!! Try this! Im using this excel as Input. [image] I’m reading this data and storing it in the “dt_input” variable. [image] I will surround my Assign activity with “Try Catch” to simulate the “Lookup DataTable” activity. If no match is found, it returns -1. We first perform a filter on the values ​​to identify the match. [image] ( From p In dt_input.Select() Where p(0).ToString.Equals(val1) and p(1).ToString.Equals(val2) Select p ).CopyToDatatable If there i…

This solution provided by @Ramya_K received 1 likes!

Check data in another file?

Filter_Non_Matching_Rows.xaml (10.6 KB) @fairymemay Please see if this workflow helps you.

---

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.