How to Exclude the Header from DT.rows.count

Help Studio
1

DT has 2 rows that includes the header. Is it possible to remove the header from DT?

Since i need to loop through and do activities based on the DT rows count

2

we have some doubts if the row count is to correct.

Give a try at:

dtVar.AsEnumerable().Skip(1).Count

with this approach we do not risk to get a row count of -1 (empty datatable) e.g. compared to the usage of dtVar.Rows.Count - 1

3

well usually DT.Rows.Count wont consider the datatable header
but if the header is captured as a first row then we can skip that row and consider the rest of records for processing
expression is same as @ppr mentioned

Cheers @Sathish_Kumar_S

4

Which variable type needs to be used to assign dtVar.AsEnumerable().Skip(1).Count value?

5

myCount | int32 = dtVar.AsEnumerable().Skip(1).Count

6

Getting below error

image
image1597×264 24.4 KB

7

so if you want the datatable itself to be skipped with first row then use the below assign activity

dt = dt.AsEnumerable().skip(1).copytodatatable

Cheers @Sathish_Kumar_S

8

we mentioned different. show us your variable panel, where the relevant variables are defined