I getting error as mention in attachment.I copy datatabble data and assign new variable OF datatype datatable
The generic type data type depends on the first variable or value given in the expression.
In your case, finalDt.Rows.IndexOf(11) will return the DataRow, so change_value1 data type is DataRow.
Here you are trying to add an integer to the data row. That’s why you are getting error.
Please fix the expression.
The expression should be like this
This will give us a output of type Datarow at position 11 in that datatable
And if we want to add to that 11
It must be
Any int32 variable is also fine like this
Using this I am only got row FinalDt.Rows(11)
My requirement is I just want column value
eg I need in Firsr row 11 column value
Then the expression be like this
can you help me on this can we do like this
the syntax is datatable.Rows(rowindex)(columnindex) which will give us the value of that particular cell position in a datatable as both row index and column index starts from 0 for first row and first column
–being a particular value it will be type string
–as we are assigning a string value to a datarow variable Current_Cal its throwing error
if we need a particular row i.e datarow then the syntax is
if we need particular row, column value then the syntax is
based on your need we can choose among the two and
and for this
first use a assign activity like this
FinalDt = FinalDt.Select("[Name] = ‘GetFilePath’ ").CopyToDatatable()
then another assign activity like this
Current_Cal = FinalDt.Rows(0) \if we want to first row as output where Current_Cal is a datarow variable
Current_Cal = FinalDt.Rows(0)(11) \if we want the value at first row and 11 th column where Current_Cal is a string variable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.