DSXchange

Posted: **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

Posted: **Mon Sep 12, 2011 9:08 am**

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

Posted: **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

Posted: **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?

DSXchange

Pivot Stage

Pivot Stage