Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 April 2022

Top 3 Topics with Most Views

📢 Launching UiPath Technology Integrations Series 2022: Alteryx, Qlik & Cyberark made by @cristina.vidu with 47 views.

How to select the policy number based on the logic made by @HeartCatcher with 44 views.

Excel起動時に出てくるポップアップ回避策について made by @r.nakanishi with 40 views.

Top 3 Topics with Most Replies

Is it Possible to have String Input as a WebPage Content? made by @hsendel with 21 replies.

Comparing two DataTables with inconsistent values made by @beepboop with 18 replies.

I have a small captcha problem made by @Vijay_Manimaran with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 33 posts!

@ushu made 21 posts!

@jack.chan made 18 posts!

Top 3 Most Liked Posts

This post made by @cristina.vidu received 2 likes!

Launching UiPath Technology Integrations Series 2022: Alteryx, Qlik & Cyberark

Time has come to restart and pick-up the pace on UiPath’s Technology Integrations Series! As an end-to-end automation platform, UiPath can integrate with various enterprise technologies to deliver maximum benefit. This is especially true for technologies we have worked on with the help of our partners: Alteryx, Qlik and CyberArk. To help you understand the best methods for integrating these services with the UiPath automation solution, we are happy to announce our next UiPath Tech…

This post made by @jeevith received 2 likes!

For each loop in group wise

Hi @Jesmine, Go with the approach @saurabhB said. That is the most robust way to get what you want. I do think you will also want to sort the other two columns when you make such groups corresponding to the name column (Sort which affects all columns). You can either use the Index ( in your case 1, or the name of the column) If the column is string, sort goes from a-z or z-a [image] When using a dummy data : [image] SortDataTable.xaml (8.4 KB)

This post made by @jeevith received 2 likes!

Storing the values in JSON output to Data table

Hi @Harsha_Vemula, There are plenty of ways to achieve this. I agree with @saurabhB that you do not need to convert to a datatable to get count of certain values. In both approaches you will need the following dependency (to ensure your input string is converted to Json object) [image] or the namespace in imports [image] The datatable approach [image] JsonCountValueUnique.xaml (9.6 KB) The query approach [image] @saurabhB you can trim down the expression even more as the Input…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

Storing the values in JSON output to Data table

Hi @Harsha_Vemula, There are plenty of ways to achieve this. I agree with @saurabhB that you do not need to convert to a datatable to get count of certain values. In both approaches you will need the following dependency (to ensure your input string is converted to Json object) [image] or the namespace in imports [image] The datatable approach [image] JsonCountValueUnique.xaml (9.6 KB) The query approach [image] @saurabhB you can trim down the expression even more as the Input…

This solution provided by @grosner received 2 likes!

How Can I use Argument or Variable in RegEx Builder Value field?

Surrounding variable name with curly braces appears to work. This is what it looks like: [uipath-RegExBuilder-with-variable] Additional Information: The variable is of type String. You can start typing the variable name and see a pop-up list of variable suggestions by first pressing the space bar.

This solution provided by @jeevith received 2 likes!

Deleting rows in a Data Table

Hi @RPA_Path, I would recommend you use the Filter Datatable Activity. Compare dates and where Date column is equal to your comparision, choose to remove that row. Finally, save the filtered datatable to the same variable as your input datatable. Essentially, you are filtering your input datatable. [image]

---

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.