How to use For Each in DataTable

[Chetan_Wagh]

Hi All,

I have read this using Read Range, Output as DT and now I want the Team Name (first column) wherever the value is greater than zero in Total column (Last column)

[Anil_G (Anil Gorthi)]

@Chetan_Wagh

If you want to filter and get only greater than zero…use a filter datatable first and add the condition

And then use for each row in datatable activity

Or …you can as well use a if condition inside your for loop to seggreate greater than zero values

Currentrow("ColumnName").ToString will give the data of each column value for each row inside the for loop

Hope this helps

Cheers

[Chetan_Wagh]

I Tried with For each row in DT but getting the following error

[fernando_zuluaga]

Hi @Chetan_Wagh

Use filter datatable activity, pass the column name and set the value as 0

or use the below linq query

(From r In dtInput.AsEnumerable
Where CInt(r("Team Name").ToString().Trim()) > 0
Select d = r).CopyToDataTable

Regards!

[Anil_G (Anil Gorthi)]

@Chetan_Wagh

Remove the inverted comma around zero… numbers dont need inverted comma

Cint(Row(3).ToString) > 0

Cheers

[Jithesh_R]

Hey @Chetan_Wagh ,

Regards,

[Chetan_Wagh]

Thank you again for the quick help @Anil_G .

[Chetan_Wagh]

Can you describe the If condition.

LMK if this is correct. IF, Row(“ColumnIndex”)>0

[Chetan_Wagh]

Ohhh.Thanks a lot

[Anil_G (Anil Gorthi)]

@Chetan_Wagh

Please try this

If(IsNumeric(Row(3).ToString),Cint(Row(3).ToString),0)>0

cheers