Hi, I want to split my excel data based on Fund number and output has to be created on its own with that fund number. For example, if i have list of funds in Excel A ie. Fund No. 100,101,102,103… I need an excel output to be created. with that fund numbers. Thanks

Hi @praneeth.v.c i was attaching the xaml it will copy the 100,101 and 102 to different excel sheets with based on the fund numbers xaml :- Saparate the data tables.zip (1.8 KB) for the reference you can see the excepted output all separately withe fund numbers [image] it will write separately…

Hi @praneeth.v.c , You can read original excel file to get data table call is dtOriginal You filter get 1 value of no , eg:100 each value have 1 data table then write each data to a file my way Split.xaml (6.8 KB) can you share your file? regards,

can you share the sample data @praneeth.v.c

Hi @Nguyen_Van_Luong1 & @Praveen_Mudhiraj cant share the file but it goes like this. I need all 100 Fnd data to be segregated and saved in new excel file. |Fund Number|Name|Region| |100|XYZ Inc.|USA| |100|ABC.Inc|USA| |100|LYM.Inc|USA| |100|REF.Inc|USA| |100|TRC.Inc|USA| |101|Agency.Inc|Amer…

Hi @praneeth.v.c , You can use filter data table

@praneeth.v.c We can model it as a GroupBy Case LINQ Approach: Assign Activity: TableList | List(Of DataTable) = (From d in YourDataTable.AsEnumerable() Group d by k=d("Fund").toString.Trim into grp=Group Select t = t.CopyToDataTable).toList The we loop over the TableList and write it back to …

[image] ppr: We can model it as a GroupBy Case Non-LINQ Approach For each Row Activity: row in YourDataTableVar.AsEnumerable.DefaultView.ToTable(true, {“Fund”}) Filter DataTable: in: YourDataTable,out: dtFiltered, Condition: “Fund” = row(“Fund”).toString write range: DataTable=dtFiltered, …

For learning purpose: [image] [HowTo] Overview on different options for grouping data and processing the groups Tutorials This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Group…

HI @praneeth.v.c you can try this xaml xaml : - Saparate the data tables.zip (2.0 KB) it will return all 100 ,101 and 102 in separate data table for the reference you can see the output 100 :- [image] 101 : - [image] 102: - [image]

Hi @Praveen_Mudhiraj Thanks for the help in this case it is copying into same excel with different sheet names but i want it to move to different excels based on fund numbers

Hi @praneeth.v.c my input and output [image] my 2 ways by LINQ and activity Filter data table Filter.zip (40.6 KB) hope it help,

Split Excel to multiple Excels

Help StudioX

Nguyen_Van_Luong1 (Nguyen Van Luong) September 20, 2023, 1:13am 11

Hi @praneeth.v.c
my input and output

my 2 ways
by LINQ and activity Filter data table
Filter.zip (40.6 KB)

hope it help,

Topic		Replies	Views
How to split an excel file into 2 files based on a list, Forum question	14	2868	September 13, 2021
Split One excel File into separate excel files Activities excel , activities , question	7	205	April 25, 2024
How to split multiple excels based on a total excel which contains department property? Help	8	1816	January 2, 2019
Split Data in Excel file into multiple Excel File Studio studio , question , activities_panel	7	722	March 22, 2023
Separate one table into another tables base on column value Academy Feedback	10	942	October 31, 2020

Split Excel to multiple Excels

Related topics