Pivot Stage

rhaddur · Post by **rhaddur** » Mon Sep 12, 2011 8:33 am

I am doing pivoting

input 3 columns
col_1,col_2,col_3
1 0 2

Output ( 2 column s
Pivote

col1 , col2
1,0,
1,2

I am getting Output
1,0
1,2
1,
i.e one extra recrod with blank col 2 generated , is this expected

chulett · Post by **chulett** » Mon Sep 12, 2011 9:08 am

Yes. Filter any 'empty' records post-pivot.

rhaddur · Post by **rhaddur** » Tue Sep 13, 2011 1:24 am

chulett wrote:Yes. Filter any 'empty' records post-pivot. ...

Can I know the root cause why we found one extra record

ray.wurlod · Post by **ray.wurlod** » Tue Sep 13, 2011 4:50 am

What does your source actually (physically) look like? Is there, for example, a final delimiter or an empty line following the data line?