Storing Datarow value in String Variable?

Help
4

HI @Shivaramthorn

Great
Kindly proceed with this, this can be sorted out very easily,

1.Lets take you have a datatable obtained from excel named out_dt
2.now use a for each row loop to iterate through this datatable with one by one datarow
3.Inside the for each row loop use a assign activity with variable to store the value from datatable like
string_value = row(ColumnIndex).Tostring
or
string_value = row(“ColumnName”).Tostring
4.Thats all you are all done

Or to get each each Datarow as a Array then
Inside the for each row use a if condition like this
String.Join(“-“,row.ItemArray()).ToString.Contains(“yourvalue”)

Hope this would help you

Cheers.

2 Likes