One row to many
Posted: Mon Feb 10, 2003 7:31 am
Hi,
I'm looking for a DataStage internal solution to this problem:
I have got a source file with semicolon separated columns like this:
A;B;Z,D,K
H;U;I,O,P,L,K
The third column is separated by comma internally.
The expected output looks like this:
A B Z
A B D
A B K
H U I
H I O
and so on.
Is it possible to do this job using a transform or routine ?
Or should I write a filter program to transform the source outside of DataStage ?
Thank you for your suggestions.
Detlev
I'm looking for a DataStage internal solution to this problem:
I have got a source file with semicolon separated columns like this:
A;B;Z,D,K
H;U;I,O,P,L,K
The third column is separated by comma internally.
The expected output looks like this:
A B Z
A B D
A B K
H U I
H I O
and so on.
Is it possible to do this job using a transform or routine ?
Or should I write a filter program to transform the source outside of DataStage ?
Thank you for your suggestions.
Detlev