Split Datatable into 4 different tables

Help Studio
5

Hi @thomasb82

Try adopting the following steps:

  1. Read the Excel file to a data table.
  2. for each row the data table
  3. check if your row number ( counter ) is > than datatable.rows.count/2. If yes, put the res on 2. new datatable. else put it in 2nd data table. Similary inherit if else for addition split of data.
  4. Save both the datatable in 2 ore more difference Excels files