Row Splitter Help !
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Row Splitter Help !
Hi,
I have to split more than 1 row from the source data comming from single Oracle stage, I ahve used Row Splitter and it works great for one row, how do I go about for more than 1 row!
Thanks a lot
I have to split more than 1 row from the source data comming from single Oracle stage, I ahve used Row Splitter and it works great for one row, how do I go about for more than 1 row!
Thanks a lot
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Just to answer the question how to concatenate all the rows into on clolumn:vinaymanchinila wrote:Hi Sai,
The source is like
'Date1,Center1,City1'
'Date2,Center2,City2'
...
'DateN,CenterN,CityN'
I am splitting the row based on the delimiter "," and how do I concatenate all the rows into one column ! It is a SQL Query that returns the rows like this and I have no fixed number of records.
Thanks,
read the flate file using delimeter other than ",", such as TAB.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am