Spliiting a single row into multiple row
Posted: Wed Aug 06, 2008 9:44 am
Hi folks,
I have the following requirement.
I have two input columns. ASSET_ID and DESC. Length of DESC field is not fixed. Output columns are same but with a fixed length of DESC field.
input row 100, WEBER MARKING SYSTEMS INC
output row should be
100, WEBER MARK
100, KING SYSTE
100, MS INC
i.e splitting the DESC field with a length of 10.
Can it be accomplished this thru transformer? If yes how?
if no, please give any ideas.
I have the following requirement.
I have two input columns. ASSET_ID and DESC. Length of DESC field is not fixed. Output columns are same but with a fixed length of DESC field.
input row 100, WEBER MARKING SYSTEMS INC
output row should be
100, WEBER MARK
100, KING SYSTE
100, MS INC
i.e splitting the DESC field with a length of 10.
Can it be accomplished this thru transformer? If yes how?
if no, please give any ideas.