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?
lakshman
(Ganta lakshman)
October 25, 2021, 1:31pm
2
@Westfield
You mean want to fill empty cell values with above row value in particular column ?
Exactly.
Take the image as an example:
I want to take the value ‘Name’ in A1 and write it to cells A2 - A8.
Hi
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
“B”+Rowcounter.ToString
Nam_Pham
(Nam Pham)
October 27, 2021, 1:09am
6
Try “Auto fill range” activities
system
(system)
Closed
October 30, 2021, 1:09am
7
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.