Split Table ?

marc

New member
I have a table.
Inside my table each rows can be a "company" or "an employee".
My table looks something like this (look at the column "RowType"):
2023-02-10_151427.png

Employees b,c,d belongs to the company a
Employees f,g,h,i belongs to the company e


I need to split my table in several text files so that each file contains maximum 100 employees. Additional difficulty: I cannot "split" into two different files some employees from the same company How do i do that?
 

Support

Administrator
Staff member
I have a table.
Inside my table each rows can be a "company" or "an employee".
My table looks something like this (look at the column "RowType"):
View attachment 214
Employees b,c,d belongs to the company a
Employees f,g,h,i belongs to the company e


I need to split my table in several text files so that each file contains maximum 100 employees. Additional difficulty: I cannot "split" into two different files some employees from the same company How do i do that?
Solution is in attachment.
 

Attachments

  • split_file_v1.anatella
    6.5 KB · Views: 12
Top