Need a logic to implement in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Mon Aug 08, 2011 3:20 am
Need a logic to implement in Datastage
my input is like :
C1 C2
--- ------
123 ABC;DEF;GEH
Output :
C1 C2 C3 C4
--- ------ ----- --------
123 ABC DEF GEH
Thanks in advance
C1 C2
--- ------
123 ABC;DEF;GEH
Output :
C1 C2 C3 C4
--- ------ ----- --------
123 ABC DEF GEH
Thanks in advance
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
first you need to let us know if the number of columns on which the data of C2 needs to divided, is fixed.
And ; is the delimiter on which it needs to be divided. Use of some plain English words to describe the situation will also help.
And ; is the delimiter on which it needs to be divided. Use of some plain English words to describe the situation will also help.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 19
- Joined: Mon Aug 08, 2011 3:20 am
Please do not come here and simply post input and output examples and ask for "logic to implement". Explain to us in words what your requirements are, what needs to be done to turn the input data into the output data. Ideally, also add what you've tried so far and what issues you have had trying to get that to work.
We're here to help people and are obviously happy to do so but we're not a service where you drop off your work then come back and pick it up later. So please help us help you by providing the above information.
We're here to help people and are obviously happy to do so but we're not a service where you drop off your work then come back and pick it up later. So please help us help you by providing the above information.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
One could use a Column Import stage with sufficient target columns.
There's no convenient way to use looping to populate an arbitrary number of target columns unless, again, you have at least sufficient target columns.
There's no convenient way to use looping to populate an arbitrary number of target columns unless, again, you have at least sufficient target columns.
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: 19
- Joined: Mon Aug 08, 2011 3:20 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: