Remove lines from datatable until its empty

[jntrk]

Hey everyone,

I have datatable which the number of rows change, I need to write the data on the table but i can only process 15 lines in at once so i will have to write first 15 lines than the other 15 untill there is nothing left.

Anysuggestions?

[Srini84 (Srinivas)]

@jntrk

Use a Do-While loop and also declare a Int32 variable

Inside that you can use Assign activity and write as below to take 15 lines

Datatable15Lines = Datatable.AsEnumerable.Take(15 * Int32Variable).CopyToDatatable

Now use another Assign activity to skip the 15 lines

DatatableNext15Lines = Datatable.AsEnumerable.Skip(15 * Int32Variable).CopyToDatatable

Increment the Int32 Variable by using Assign → Int32Variable = Int32Variable+ 1

Hope this will help you

Thanks

[jntrk]

Okay, but what will be the condition of do while? Like I said i dont know the row size it may change from time to time the condition should be that the datatable is empty, so how can i write it

[ppr (Peter)]

Have a look here:

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: …

Adding Sheets till specific value

@Daniyal_Tahir Logic is same a described in the links. It is just modified to write out the Excel Sheets Variables: [grafik] Flow: [grafik] Statements: NoOfSegments = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize)) segment = Enumerable.Range(0,NoOfSegments).ToList RowSet = dtData.AsEnumerable.Skip(segment*SegmentSize).Take(SegmentSize).toList Find starter Help: SplitTable_BySegmentSize_ToTable_WriteSheet.xaml (13.0 KB)

[Srini84 (Srinivas)]

@jntrk

You can use Assign activity and write as below

IntDivideVariable = dt.Rows.Count / 15

Now write as IntDivideVariable <> Int32Variable

Hope this will help you

Thanks