I need to fill a column with one specific date. When I use auto fill activity, it fills in a data series even if I provide the first two “source cells” with the specific date.
Example what I get:
01.04.2020
01.04.2021
01.04.2022
…
Example what I need:
01.04.2020
01.04.2020
01.04.2020
…
Does anybody have an idea how to do this?
Thank you!
You can use Read Range to read in the data, then use a For Each Row activity to set the value of each cell to the specific value you want. Then use the Write Range activity to set the data in the Excel workbook.
Thanks for your suggestion.
I already thought about this, but I need to do this for around 250 000 rows. I think this will require a lot of time.
Is there any other way to do this?
Yes, but then I would have to use for each as well and add a new row with the value 250 times. Or is there another way to create a data table with 250 rows and assign the same value to all rows “at the same time”?
Hi @silvia93, I had the same problem but at the end I used read cell activity to read cell value and then write cell activity where i used the range for example “A1:A10000”