single row spliting into Multiple rows

vinsashi · Post by **vinsashi** » Thu Nov 19, 2009 12:58 am

Hai,
My source data CONTAINS ONLY ONE COLUMN
Column1 COLUMN2
AAA,BBB,CCC TAB1
DDD TAB2
EEE,FFF,GGG,HH,II TAB3

I NEED OUTPUT LIKE
COLUMN1 COULMN2
AAA TAB1
BBB TAB1
CCC TAB1
DDD TAB2
EEE TAB3
FFF TAB3
GGG TAB3
HH TAB3
II TAB3

Thanks in adavance
vinsashi

DS_SUPPORT · Post by **DS_SUPPORT** » Thu Nov 19, 2009 1:16 am

Did you tried using Pivot Stage?

vinsashi · Post by **vinsashi** » Thu Nov 19, 2009 1:38 am

I have tried with pivot also but not working..
actually what i did
i have taken only one column
Column1
AAA,BBB,CCC
EE,FF
GG,HH,II
just what idid i have loaded into sequntial file here i mentioned record delimeter string as ',' and final delimeter as 'end'
then i am getting correct output
Column1
AAA
BBB
CCC
EE
FF
LIKE THIS
BUT WHEN I AM TAKING TWO COLUMNS
COLUMN1 COLUMN2
AAA,BBB,CCC TAB1
EE,FF TAB2
IN THIS SCENARIO I AM NOT GETTING CORRECT OUTPUT.

THANKS IN ADAVANCE FOR UR REPLY
VIN....

pathipati.ds · Post by **pathipati.ds** » Thu Nov 19, 2009 2:57 am

can u try with record delimiter string

vinsashi · Post by **vinsashi** » Thu Nov 19, 2009 3:03 am

Hi Pathipati,
Thanks for ur reply..I have mentioned in the above how i tried.if i have single column its working.if more than 1 column in input its not working..any other idea to solve that one...

Thanks in adavance
vin...

pathipati.ds · Post by **pathipati.ds** » Thu Nov 19, 2009 3:35 am

Can u try with record delimiter string=dos format?