i have a job to write the below values to a file(delimited)
Number,Filename
1,File1.txt
2,File2.txt
3,File3.txt
How can i extract and pass the values into Startloop and Endloop activity.
do i need nested loop for this?
Please suggest me.
Startloop and Endloop activity.
Moderators: chulett, rschirm, roy
Startloop and Endloop activity.
Regards
LakNar
LakNar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't really know what you want to achieve. Is it a list of the numbers, or a list of the file names, or a list of the pairs, that you wish to pass to the Start Loop activity?
The easiest way is to use an upstream Execute Command activity to read the file (perhaps with filtering), then a user variable to map the line terminators (which by now are probably field marks) to a delimiter character that you will be specifying in the Start Loop activity.
The easiest way is to use an upstream Execute Command activity to read the file (perhaps with filtering), then a user variable to map the line terminators (which by now are probably field marks) to a delimiter character that you will be specifying in the Start Loop activity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I gave you a solution. All you need to do is purchase a premium membership so you can read it.
Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. It's not expensive, at less than 30c (Rs 12) per day, and there is an increasing set of benefits.
Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. It's not expensive, at less than 30c (Rs 12) per day, and there is an increasing set of benefits.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.