Linq Query to filter the Data Table based on the Region

[Nissy_Ruth_Prabhu (Nissy Ruth)]

Filter_by_Region.xaml (11.5 KB)
Join Tables Linq.xaml (7.6 KB)
Separate_Sheets.xaml (9.7 KB)
Workbook_Sheets.xaml (7.3 KB)
Write_grade_from _percentage.xaml (15.8 KB)
Xaml file to filter the data Table based on the Region.

[postwick (Paul Ostwick)]

Why not just use the Filter Data Table activity? Quick and easy.

[Nissy_Ruth_Prabhu (Nissy Ruth)]

Yes , we can, but the approach is using the LInq Queries , just to learn the usage of the LinQ queries, I find Linq is more intresting .

[postwick (Paul Ostwick)]

Then I suggest searching the forums. It’s a great way to find what you’re looking for.

How to apply date filter using LINQ in UiPath

Problem statement : We have a datatable that contains the order details for all customers for past few years and we need to extract the data only for one specific year [SampleData] In the above datatable as you can see we have records from 2021 and 2022 and we need to extract the records for year 2021 only. Here is how you can do it Drag the assign activity to the workflow, write the following query [Query] Run the program and see the magic YouTube: How to apply date filter u…

[supermanPunch (Arpan)]

@postwick

Then I suggest searching the forums. It’s a great way to find what you’re looking for.

Hi @Nissy_Ruth_Prabhu ,

We are noticing you are providing the References for Possible Solutions on different Topics.

Just to differentiate between a Query and a Solution/Tutorial post, You could add the necessary tags to the Topic (such as Tutorial, Solution, Knowledge Base) and maybe a One liner description of what the Solution does, so that other users would be able to understand that the posted Topics are not Queries in need of answers

[mkankatala (Mahesh Kankatala)]

Hi @Nissy_Ruth_Prabhu

If you want to learn the LinQ queries from the foundation, do check the below thread which really helps you to learn LinQ queries easily.

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

Hope it helps!!

[ppr (Peter Preuss)]

we agree to

@supermanPunch

You could add the necessary tags to the Topic (such as Tutorial, Solution, Knowledge Base) and maybe a One liner description of what the Solution does

When

@Nissy_Ruth_Prabhu

just to learn the usage of the LinQ queries

then we would also recommend providing all related materials (e.g. used Excel files). So someone else has a chance to follow and inspect the details

[Nissy_Ruth_Prabhu (Nissy Ruth)]

Thank you for the Suggestions, will update accordingly.