When we are using column import stage then you need to take care in defining the column order in the output mapping page.
Recently one of my friend called me for a different problem. She said that in her job at a particular stage the data is getting rotated. Means she is expecting data as follows
Col1 Col2 Col3
——————–
D1 D2 D3
but she is getting data like this
Col1 Col2 Col3
——————–
D3 D1 D2
She said she checked all the mapping and every thing looks good. But still the problem this there.
The actual problem is in the column import stage the column order in the output mapping was like this,
Col1
Col2
Col3
in Left hand side and
Col 3
Col 1
Col 2
but the column mapping was done correctly from Col1 — > Col 1, Col2 –> Col2 and Col3 –> Col3
Then i found out that the reason is that we need to define the columns in the order.. We need to keep the columns in the same order on the output page means as follows,
Col1 Col1
Col2 Col2
Col3 Col3
Now only you will get the correct output.