Use the read CSV activity, and then a for each row to go through each row item in DataTable.
You can then use row("ColumnName").ToString() to access each row item in that column.
use assign activity with following datatableName.DefaultView.ToTable(False,{“Name”,“Country”,“Gender”})
if you want distinct values among those 3 columns, replace False with True
Use For each row in Datatable_Variable and inside for each row, you can assign it to individual string variables.
Like this
name = row(“yourcolumnname”).ToString
Or
name = row(columnindex).ToString
Where column index starts from 0 for first column in excel
I think the cause for the error is you used “For Each” to loop through the datatable, where you should use “For Each Row” to loop through the datatable.
To show the values you could use something like a writeline with this statement: row("Name").ToString() + ", " + row("Country").ToString() + ", " + row("Gender").ToString()
I built a datatable like yours, and looped through the rows. Please let me know if this helped.