Filter datatable based on criterias only based on Branch

[Kunal_Jain]

Hi,
I have a datatable, and I have to filter it based on some criteria.
(It contains repeated values just get them once)
The Criteria is it must be divided only for plants and distribute the data in different datatables
I have attached the Input Sheet for the same.

According to the input we will get different datatables as output.
I have attached the output sheet for the same.

Please let me know how to solve the issue?
(Mainly how to get the non repeated values for the 1st column)
Thanks in advance!!

[ppr (Peter Preuss)]

Assign Activity:
TableList | DataType: List(Of DataTable) =

(From d in YourInputDT.AsEnumerable
Group d by k= d("Branch").toString.Trim into grp=Group
Select g = grp.CopyToDataTable).toList()

Then loop over TableList and write out each Branch table to Excel

[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 - Help / Something Else - UiPath Community Forum

[Kunal_Jain]

Hi @ppr
How to get it in the form of different datatables and also will this code five the output same as I have provided the Output sheet containing 8 different sheets?
Thanks in advance!!

[ppr (Peter Preuss)]

@Kunal_Jain

How to get it in the form of different datatables

we mentioned the tablelist / here each group is split and a datatable

@Kunal_Jain

five the output same as I have provided the Output sheet containing 8 different sheets?

when 8 different Branches are within the Input then 8 different Tables are within the output

Also we can adapt and add some more filter and split logic.

However we recommend,

• that you will start actively with modelling the first prototype
  And/Or
• used the attached ressources when more training starter help is wished

[Kunal_Jain]

Hi @ppr
I am a bit confused with the approach.
Because I have tried and ran the solution but it is not giving the desired output
It is just writing for Branch 1507 and Cost 10 and 7

And also repeated values are also there.
Thanks!!

[ppr (Peter Preuss)]

sharp the requirements and we will finalize with you

[Kunal_Jain]

Hi @ppr
We have the data mixed in the input sheet
But we need to divide the data based on Branch and all the value has to be written just once no repetition
I have provided the output sheet in which format the output is required.
OutputSheet.xlsx (14.6 KB)
The output has to be in the above provided format.
Thanks!!

[ppr (Peter Preuss)]

@Kunal_Jain

But we need to divide the data based on Branch

Maybe you are looking for a more fine granular grouping where the groups as rated on Branch and Costs

thats why we also recommended:

@ppr

sharp the requirements and we will finalize with you

so have a look on more grouping basics: Link above

And:

TableList | DataType: List(Of DataTable) =

(From d in YourInputDT.AsEnumerable
Group d by k1= d("Branch").toString.Trim, k2= d("Cost").toString.Trim into grp=Group
Select g = grp.CopyToDataTable).toList()

[ppr (Peter Preuss)]

FYI (with an additional ordering)

(From d In dtData.AsEnumerable
Group d By k1= d("Branch").toString.Trim, k2= d("Cost").toString.Trim Into grp=Group
Order By CInt(k1), CInt(k2)
Select g = grp.CopyToDataTable).toList()

etc:

@Kunal_Jain

The output has to be in the above provided format.

looks like your sample output has also shortened the input data groups