Hi, I hope someone can help me come up with a solution for this.
Say that I need to extract a value from row A1 in a data table and then write that value to a certain number of rows below the row where I found the original value, in the same column.
Does anyone have a good idea how I might do this?
You mean want to fill empty cell values with above row value in particular column ?
Take the image as an example:
I want to take the value ‘Name’ in A1 and write it to cells A2 - A8.
Use a read cell activity and mention the cell position from where we want to read the cell value and save it in a string variable
Then use a WRITE CELL ACTIVITY to write it back to the cell you want may be within a loop like this
Use a WHILE activity like this
with a condition
Rowcounter < 9
Where rowcounter is a variable of type int32 with default value as 1 defined in variable panel
- Now inside the loop use a write cell activity with the value as string variable obtained from read cell and cell range a
Try “Auto fill range” activities
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.