How filter data in Datatable I want to data of dissimilar data I want only 3 6 9 12 no of rows

Sachin_Bile · February 1, 2023, 4:54am

arjunshenoy · February 1, 2023, 4:57am

Hi @Sachin_Bile , Welcome to the Community.

Can you please be more clear about dissimilar data? Like what are the basic criteria that you need to filter the data table?

Aakash_Singh_Rawat · February 1, 2023, 5:05am

Use assign:
new_dt = dt.AsEnumerable.Where(Function(x) dt.Rows.IndexOf(x) Mod 3=0).CopyToDataTable

mod 3=0 is for selecting rows by index which are divisible by 3 and dt is your output datatable used in Read Range.

Please mark this as solution if it solves your problem.