Storing Datarow value in String Variable?

[Shivaramthorn]

I am using multiple excel files and checking data dynamically so sometimes i need data from datatable and check condition with string variable so there is a issue. When i used writeline(Activity) the output i Got is System.Data.Datarow[] which is the data type but expected output is String value.

[bcarp (Bryan Carpenter)]

I think this may help you:

How to Display DataRow Array

Hi, May i ask how do i display a DataRow array using Writeline? I am doing this to check whether the values filtered from the data table is correct.

[swapan]

@bcarp how we can store datarow results in variable?, with logmessage and writeline working fine

[Palaniyappan (Palaniyappan P)]

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.