Repeat Action by number of times in excel

Help Activities
, ,
1

I tried searching in the forum.
But no result
I have this excel file
image

image
image420×822 20.1 KB

I take action to create .txt file with Excel content

How can I create multiple files according to the number of times in the “loop” and the filenames are changed according to that sequence number.
I would like to receive:
line1:

  • “+red5+”.“+red7+”.number1.txt"
  • …
  • “+red5+”.“+red7+”.number5.txt"
    line 2:
  • “+red5+”.“+red7+”.number1.txt"
  • “+red5+”.“+red7+”.number2.txt"
    regards
2

Hey!

The flow which you’re designed is absolutely correct…

But we can’t create the file with Double quotes…

You can create the file with single quote…

The flow is correct this will iterate through all the rows and will create the new files based on the row data…

If you’re getting any error could you please show us the error?

Regards,
NaNi

3

Hello @VuCamp

image
In highlighted field type below

"\key\"+red5+"."+red7+".number"+(curr_rw_index+1)+".txt"

you can create the curr_rw_index variable in properties pane of for each row

image

1 Like
4

thank you my friend
It helped me

1 Like
5

Great !
Please mark my post as Solution.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.