DataTable Error Column

Hello,

I have a data table. 3 row 5 columns.

How do I get the value in the 3rd column?

Hi!

Follow the below steps.

  1. Take one workbook read range activity-> output as β†’ Dt_out-> variable type Data table
  2. Take one for each row in Data table activity-> pass the Dt_out variable here…
  3. Take one assign activity β†’ crate one string variable β†’ Col3 pass the value like this
CurrentRow("Column name").ToString.Trim

Or

CurrentRow("ColumnIndex").ToString.Trim

Nite: Column index will start from Zero(0)

This will display the particular column values.

Take one message box and pass the Col3 variable here

You can see the values (Each iteration time one value)

Try this and let me know

Regards,
NaNi

we can acces directly like:
YourDataTableVar.Rows(RowIndex)(ColumnIndex).toString

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.