How to copy same data into particular column without using for loop?

image
This is my input file i want to add the current date in date column without using for loop … Because i have the big data set so in here for loop is not useful.

I used this logic for this but i am getting output like this:
image
In here year is getting increment by 1

My expected ouput is:
image

My workflow:
Main.xaml (8.5 KB)

Hi @NervousTuber

Try Like this
image

Regards
Sudharsan

2 Likes

its not working

Can your share a snap of your flow so that we will find out what the issue is ?

i already attached into the post
Main.xaml (8.5 KB)

Okay try this way

  • Write cell in B2 “date”
  • Write cell in B3 “=B2”
  • USe Autofill range

Regards
Sudharsan

Try out this xaml file

Main (3).xaml (8.6 KB)

Thanks,
Robin


nope years are getting increment

For Each loops are not slow. Everything loops. Stop worrying about avoiding For Each loops.

yeah i know for loop is best… and already used for loop in this problem… But i want to know is there any other way to do this?

I figured it out .
Thanks guys for your help
I assigned this outputDt = outputDT.RowCount + 1 then i simply add the write range activity with the range of “K3:K”+ColumnRange.ToString