Generate a sequence iteration wise

sgnarkhede2016
New Altair Community Member
Hello,
I want to generate a sequence like.
In my first loop, Five customers is coming then I will generate Id 1 to 5
In the next loop 7 Customer is coming I want to start Id from 6 and so as per iteration.
I want to generate a sequence like.
In my first loop, Five customers is coming then I will generate Id 1 to 5
In the next loop 7 Customer is coming I want to start Id from 6 and so as per iteration.
Tagged:
0
Best Answer
-
@sgnarkhede2016 you'll need to Use Loop Batches, Generate ID, Extract Macro operator to do what you are trying to achieve.
You'll extract the Max ID that was created with the extract Macro and then Use it as a parameter for the offset in the Generate ID.
1
Answers
-
Hi,have you checked the operator Generate ID?Best,Martin0
-
@sgnarkhede2016 you'll need to Use Loop Batches, Generate ID, Extract Macro operator to do what you are trying to achieve.
You'll extract the Max ID that was created with the extract Macro and then Use it as a parameter for the offset in the Generate ID.
1 -
But first time i need to pass offset value is like 1 or 101 next time i will get Max_Id in macro max but how to pass that max macro in generate Id for next iteration
e.g I have used branch, give condition if iteration==1 then I pass in offset =0 and store max id in Max_Id macro and In Else part I have mentioned in Generate Id Offset %{Max_Id}0