How to use LINQ Query to develop a task in UiPath studio

[TIN_RPA]

Hi Everyone,

I would like to ask a question on LINQ Query, I want to develop a UiPath workflow that extracts data from an Excel file, manipulates it using LINQ, and writes the processed data to a new Excel file or another target (e.g., Data Table).

Scenario-

I have an Excel file containing customer data (ID, Name, Email, Order Amount, City). The task is to:

1. Read the data from the Excel file.
2. Use LINQ to:

• Filter customers who have placed an order exceeding a specific amount (provided as an input variable).
• Calculate the total order value for all customers.
• Group customers by city and find the average order value for each city.

3. Write the processed data (filtered customers, total order value, city-wise average) to a new Excel file or a DataTable.

I would appreciate a prompt reply !!

Thank you very much in anticipation.

Regards,
TIN RPA

[ashokkarale]

@TIN_RPA,

Try to specify issue you are facing.

Thanks,
Ashok

[ppr (Peter Preuss)]

Have a Look at the basics for

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode th…

[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…

[TIN_RPA]

Hi @ashokkarale,

• Filter customers who have placed an order exceeding a specific amount (provided as an input variable)- got this by using Linq query - (From row In Table_DT.AsEnumerable()Where Convert.ToInt32(row(“Order Amount”)) > SpecficAmount Select row).CopyToDataTable

• Calculate the total order value for all customers- Got this by using- (From row In Table_DT.AsEnumerable() Select Convert.ToInt32(row(“Order Amount”))).Sum()

• Group customers by city and find the average order value for each city- not getting this by using- CityGroups_En As IEnumerable(Of CityOrderInfo) = From row In FilteredCustomers_DT.AsEnumerable() Group row By city = row.Field(Of String)(“City”) Into Group Select New CityOrderInfo With {.City = city, .AverageOrderValue = Group.Average(Function(r) Convert.ToInt32(r.Field(Of Integer)(“Order Amount”)))

Plesae help me on this where I am doing wrong.

Thanks