Generate a sequence iteration wise
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.
Find more posts tagged with
Sort by:
1 - 3 of
31
Altair EmployeeHi,
have you checked the operator Generate ID?
Best,
Martin
Altair Employee@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.
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.
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}
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}
Sort by:
1 - 1 of
11
Altair Employee@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.
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.