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

Help StudioX
,
1

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)

2

Hi @Vinit_Mhatre

Try Like this
image

Regards
Sudharsan

2 Likes
3

its not working

4

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

5

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

6

Okay try this way

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

Regards
Sudharsan

7

Try out this xaml file

Main (3).xaml (8.6 KB)

Thanks,
Robin

8

image
image176×913 3.63 KB

nope years are getting increment

9

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

10

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?

11

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