Repeat Action by number of times in excel

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


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

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

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

thank you my friend
It helped me

1 Like

Great !
Please mark my post as Solution.

1 Like

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