Page 1 of 1
single row spliting into Multiple rows
Posted: Thu Nov 19, 2009 12:58 am
by vinsashi
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
Posted: Thu Nov 19, 2009 1:16 am
by DS_SUPPORT
Did you tried using Pivot Stage?
Posted: Thu Nov 19, 2009 1:38 am
by vinsashi
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....
Posted: Thu Nov 19, 2009 2:57 am
by pathipati.ds
can u try with record delimiter string
Posted: Thu Nov 19, 2009 3:03 am
by vinsashi
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...
Posted: Thu Nov 19, 2009 3:35 am
by pathipati.ds
Can u try with record delimiter string=dos format?