How to create a column with batch number in a datatable

[yusuf]

Dear Developers, i have a table with over 400++ line items…i want to create a column named “Batch” and write batch number by number of rows. first 100 rows is for batch 1, next 200 belongs to batch 2… and so forth. Kindly need your expertise. really appreciate a method which does not use for each row as it might be time consuming. Thank you in advance,

[Yoichi]

Hi,

Can you try the following sample?

dt = dt.AsEnumerable.Select(
Function(r,i)
    r("Batch")=1+(i \ 100)
    Return r
End Function
).CopyToDataTable

Sample20230306-4aL.zip (2.7 KB)

Regards,

[yusuf]

@Yoichi

dt = dt.AsEnumerable.Select(
Function(r,i)
    r("Batch")=1+(i \ 100)
    Return r
End Function
).CopyToDataTable

dear @Yoichi , this works just perfect. thank you so much for your fast response