ROW SPLITTER PROBLEM
Posted: Mon Jul 11, 2005 4:39 am
I've found topics on rowsplitter but they don't give me an answer to my particuler problem.
I have an Oracle table that contains columns :-
Orderref varchar(6)
Status varchar(2)
Submission_Tstamp Timetamp (19)
Order_Data varchar(2040)
Order_Data contains information about options the customer selected when placing the order. The option codes appear at 12 character intervals.
e.g.
code1.......code2.......code3.......code4 e.t.c.
I am trying to break the Order_Data column into multiple rows so I end up with :-
e.g.
OrderRef Status Submission_Tstamp Option
====== ==== ============= ====
000001 01 2004-07-11 00:00:00 Code1
000001 01 2004-07-11 00:00:00 Code2
000001 01 2004-07-11 00:00:00 Code3
000001 01 2004-07-11 00:00:00 Code4
I am using a job :-
OCI ==> Row Splitter ==> seq File
If on the output I specify the single column Option varchar(12) as fixed width(12) it works o.k.
Option
====
Code1
Code2
Code3
Code4
but as soon as I try to add in the other columns I want passed through I start to have problems. Either "Required Column Missing" which they aren't as they are specified in the OCI source stage.
If I turn of the Missing column message then it tries to split the Order_Data column over the extra columns
e.g.
OrderRef Status Submission_Tstamp Option
====== ==== ============= ====
Row1 Code1 Co de2Code3Code 4000001
or something close to that.
Is there some setting that I am missing?
I've tried swapping the order of the columns around to no avail.
Can anybody help ?
ianm
I have an Oracle table that contains columns :-
Orderref varchar(6)
Status varchar(2)
Submission_Tstamp Timetamp (19)
Order_Data varchar(2040)
Order_Data contains information about options the customer selected when placing the order. The option codes appear at 12 character intervals.
e.g.
code1.......code2.......code3.......code4 e.t.c.
I am trying to break the Order_Data column into multiple rows so I end up with :-
e.g.
OrderRef Status Submission_Tstamp Option
====== ==== ============= ====
000001 01 2004-07-11 00:00:00 Code1
000001 01 2004-07-11 00:00:00 Code2
000001 01 2004-07-11 00:00:00 Code3
000001 01 2004-07-11 00:00:00 Code4
I am using a job :-
OCI ==> Row Splitter ==> seq File
If on the output I specify the single column Option varchar(12) as fixed width(12) it works o.k.
Option
====
Code1
Code2
Code3
Code4
but as soon as I try to add in the other columns I want passed through I start to have problems. Either "Required Column Missing" which they aren't as they are specified in the OCI source stage.
If I turn of the Missing column message then it tries to split the Order_Data column over the extra columns
e.g.
OrderRef Status Submission_Tstamp Option
====== ==== ============= ====
Row1 Code1 Co de2Code3Code 4000001
or something close to that.
Is there some setting that I am missing?
I've tried swapping the order of the columns around to no avail.
Can anybody help ?
ianm