I'm having trouble in looping with in the sequencer:
My job design is
StartLoopA---->JobActivityA----->StartLoopB----->JobActivityB---->EndloopB---->EndloopA
My first loop (StarLoopA) contains Monday and Tuesday (list loop) and my second loop (StarLoopB) containing 01 and 02 (list loop), I need that the first cycle is Monday01 closure and begin another cycle where Tuesday02 which increase the two loop for the second record.
My problem is that the second loop runs 2 times
Thank for your help..
Javier
Loop Activity Problem
Moderators: chulett, rschirm, roy
Loop Activity Problem
Consultant in DTS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This morning it looks unresolved. [shrug]
You've marked this as a 'TX' job and posted in the Server forum. Doesn't matter per se if you are asking about a Sequence (no 'r') job but make sure you set that appropriately in the future.
Can you explain what your design is meant to do in words please? Better words, that is. Right now you've got a loop inside a loop and from what I can understand from your post, it sounds like it is doing exactly what it should.
If that's not correct, we need a better explanation of what it is you need.
You've marked this as a 'TX' job and posted in the Server forum. Doesn't matter per se if you are asking about a Sequence (no 'r') job but make sure you set that appropriately in the future.
Can you explain what your design is meant to do in words please? Better words, that is. Right now you've got a loop inside a loop and from what I can understand from your post, it sounds like it is doing exactly what it should.
Code: Select all
A: Monday
B: Monday 01
B: Monday 02
A: Tuesday
B: Tuesday 01
B: Tuesday 02
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Loop Activity Problem in more detail
Hello again, here is the structure that I want to do.
A: Monday
B: Monday 01
Activity
Exit from B
A: Tuesday
B: Tuesday 02
Activity
Exit from B
I want to execute A with Monday go inside the B loop with Monday and 01, and execute the second loop only once.
Then execute Tuesday in A and go inside the B loop with 02 only, I mean execute B loop only once again.
I prefer to use Loop Stages, if it is possible, because the two lists are hard code. I want to combine the first field of the fist list with the first field of the second list and the second time the second field of the first list with the second field of the second list.
Thanks, if you need more detail please let me know.
A: Monday
B: Monday 01
Activity
Exit from B
A: Tuesday
B: Tuesday 02
Activity
Exit from B
I want to execute A with Monday go inside the B loop with Monday and 01, and execute the second loop only once.
Then execute Tuesday in A and go inside the B loop with 02 only, I mean execute B loop only once again.
I prefer to use Loop Stages, if it is possible, because the two lists are hard code. I want to combine the first field of the fist list with the first field of the second list and the second time the second field of the first list with the second field of the second list.
Thanks, if you need more detail please let me know.
chulett wrote:This morning it looks unresolved. [shrug]
You've marked this as a 'TX' job and posted in the Server forum. Doesn't matter per se if you are asking about a Sequence (no 'r') job but make sure you set that appropriately in the future.
Can you explain what your design is meant to do in words please? Better words, that is. Right now you've got a loop inside a loop and from what I can understand from your post, it sounds like it is doing exactly what it should.
If that's not correct, we need a better explanation of what it is you need.Code: Select all
A: Monday B: Monday 01 B: Monday 02 A: Tuesday B: Tuesday 01 B: Tuesday 02
Consultant in DTS
Loop Activity Problem in more detail
Hello again, here is the structure that I want to do.
A: Monday
B: Monday 01
Activity
Exit from B
A: Tuesday
B: Tuesday 02
Activity
Exit from B
I want to execute A with Monday go inside the B loop with Monday and 01, and execute the second loop only once.
Then execute Tuesday in A and go inside the B loop with 02 only, I mean execute B loop only once again.
I prefer to use Loop Stages, if it is possible, because the two lists are hard code. I want to combine the first field of the fist list with the first field of the second list and the second time the second field of the first list with the second field of the second list.
Thanks, if you need more detail please let me know.
A: Monday
B: Monday 01
Activity
Exit from B
A: Tuesday
B: Tuesday 02
Activity
Exit from B
I want to execute A with Monday go inside the B loop with Monday and 01, and execute the second loop only once.
Then execute Tuesday in A and go inside the B loop with 02 only, I mean execute B loop only once again.
I prefer to use Loop Stages, if it is possible, because the two lists are hard code. I want to combine the first field of the fist list with the first field of the second list and the second time the second field of the first list with the second field of the second list.
Thanks, if you need more detail please let me know.
chulett wrote:This morning it looks unresolved. [shrug]
You've marked this as a 'TX' job and posted in the Server forum. Doesn't matter per se if you are asking about a Sequence (no 'r') job but make sure you set that appropriately in the future.
Can you explain what your design is meant to do in words please? Better words, that is. Right now you've got a loop inside a loop and from what I can understand from your post, it sounds like it is doing exactly what it should.
If that's not correct, we need a better explanation of what it is you need.Code: Select all
A: Monday B: Monday 01 B: Monday 02 A: Tuesday B: Tuesday 01 B: Tuesday 02
Consultant in DTS
Then you want one loop, not two. And since (AFAIK) you can't iterate through linked lists of variables, you'll need to build your single list with both pieces. For example, the List Loop:
Monday|01,Tuesday|02
Then use the Field() function to split around the pipe for each parameter value. Now, since your second value matches the loop counter, it seems you could dispense with the second list and use a single loop with your original two days. Then for the second parameter, just pass $Counter. Never tried using it by itself, but seems like it should work.
Let us know.
Monday|01,Tuesday|02
Then use the Field() function to split around the pipe for each parameter value. Now, since your second value matches the loop counter, it seems you could dispense with the second list and use a single loop with your original two days. Then for the second parameter, just pass $Counter. Never tried using it by itself, but seems like it should work.
Let us know.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Craig
I apply your sugestion and it work!!!
Thank you so much
Javier
I apply your sugestion and it work!!!
Thank you so much
![Cool 8)](./images/smilies/icon_cool.gif)
Javier
chulett wrote:Then you want one loop, not two. And since (AFAIK) you can't iterate through linked lists of variables, you'll need to build your single list with both pieces. For example, the List Loop:
Monday|01,Tuesday|02
Then use the Field() function to split around the pipe for each parameter value. Now, since your second value matches the loop counter, it seems you could dispense with the second list and use a single loop with your original two days. Then for the second parameter, just pass $Counter. Never tried using it by itself, but seems like it should work.
Let us know.
Consultant in DTS