Split data table save 2 datatables

[alexis.mendoza]

hello, please your help.

I have a data table, if this data table has more than 100 rows, it should be divided into 2 and the 2 parts should be in two different variables.

[fernando_zuluaga]

hey

check this example to get the last rows

Data Scrapping Suggestion

You can’t directly skip the rows while data scraping. Instead you fetch all pages and take only the required number of rows from the scraped data table. newdt = myDataTable.AsEnumerable().Skip(skipRows).Take(50).CopyToDataTable Skip - Will skip the unwanted rows Take - Will take the next 50 rows Regards, Karthik Byggari

use this for first rows

dt1 = Dt.AsEnumerable().Take(80).CopyToDataTable()

regards!

[alexis.mendoza]

Claro, una combinación de ambas.

[alexis.mendoza]

Disculpa y si requiriera dividirla en 3?

[fernando_zuluaga]

supongo que podrias hacer un dt.rowCount de la DT y divir ese valor en 3, y asi le pasas cada valor que necesites al Skip y al Take.

lo que no entiendo es para divifirlas?

[alexis.mendoza]

Usar esta instrucción conservara los encabezados?.

es parte del proceso para eso se dividide, entonces por archivo no puede tener mas 100 lineas.

[ppr (Peter Preuss)]

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …

Split Datatable into 4 different tables

@thomasb82 lets assume following variables: [grafik] NoOfSegments is indicating how many splits we do want have Doing an integer division to find out how many rows will be in a split (we cannot fetch a rows count with fractions e.g. 14.25 rows [grafik] with following LINQ we can produce a list of datatables with the splits: [grafik] (From i In Enumerable.Range(0,NoOfSegments) Let opart = dtData.AsEnumerable.Skip(i*FullSegmentSize).toList Let spart = If(i = (NoOfSegments - 1), opart, opa…

Compare if different rows have the same value

@Aleix_Paytuvi have a look here: Just extend the demo with a later for each (TypeArgument datatable) and iterate over the table list. The different Datatables can be written to Excel with a write range