Happydayyy
(22035153d)
February 14, 2024, 12:34pm
1
Actually I am following her video in spilting data to multiple sheet based on “Type”. It’s ok to spilt out multiple sheet?
For example, one sheet is for ‘Type (4N)’ and paste all column data for 4N;one sheet is for ‘Type (3N)’ and paste all column data for 3N.
When i follow her video, i got some issue as follows
After I paste the data from 2.1 Summary, it is supposed that it can generate different sheet based on "Type”, but there is something went wrong
ppr
(Peter Preuss)
February 14, 2024, 12:55pm
2
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…
Assign Activity
TableList | List(Of DataTable) =
dtData.AsEnumerable().GroupBy(Function (x) x("Type").toString.toUpper.Trim).Select(Function (x) x.CopyToDataTable).toList
Then loop over the Table List and write out ech iterated Table to a Worksheet
Worksheetname = LoopedTableVar.Rows(0)(“Type”).toString
Happydayyy
(22035153d)
February 14, 2024, 2:51pm
3
MU real.xaml (16.5 KB)
I am still confusing
can you help me to check where I should do this aasign and what I need to make edit? Thank you
Happydayyy
(22035153d)
February 14, 2024, 2:53pm
4
May i ask I still need to keep this acvtivity or delete it?