DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
new2ds2011



Group memberships:
Premium Members

Joined: 21 Jan 2011
Posts: 2

Points: 26

Post Posted: Mon Feb 07, 2011 10:24 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Datastage 8.1

i have a source table as the following

ID # of email email
---- ----------- ------
1 2 abc@abc.com, bcd@bcd.com
2 3 jfk@jfk.com, a2z@a2z.com, bbb@bbb.com

I need to make each email address a record so the data in the target table will look like this

ID email# email
---- --------- -----------
1 1 abc@abc.com
1 2 bcd@bcd.com
2 1 jfk@jfk.com
2 2 a2z@a2z.com
2 3 bbb@bbb.com


I am new to DataStage, and have been reading the 'Restructure' categories, but haven't figured out yet. Stored procedure stage would be an option, I suppose.

Thanks in advance.
new2ds
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 51954
Location: Las Vegas
Points: 282080

Post Posted: Mon Feb 07, 2011 12:02 pm Reply with quote    Back to top    

Welcome aboard. That style of looping is available in version 8.5. In earlier versions the easiest approach is to re-parse the comma delimited field into separate fields (perhaps using Column Import stage) then Pivot.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours