How to increment variable after certain number of rows

Automation Studio
1

Hello,

I am using advanced loop on a text file that has lets say 900 rows. I need to assign a variable to every 200 rows and then increment it by 1. For e.g.:
if row number <=200 then x=1
if row number >200 and row number <=400 then x=2
if row number >400 and row number <=600 then x=3
and so on…

Could you please help me with this?

2

Hi,

You can use an argument to keep track of iteration count which map with row number and use if else activity to assign value to variable x depending on iteration count.

Regards,
Amit