DSXchange

For some stages like pivot and aggregator stage one of output column of has a special character (new line e.g one rectangle box) appended with output data.

Please clarify me why these stages are appending a new line character? How can we rectify this problem?

Note: We have checked the source data for pivot stage which does not have any new line characher as input but the output has it. Same thing with aggregator stage.

Writing into a fixed width file? Is the 'rectangle box' appended to fields which are defined as type char? Set the APT_PAD_CHARACTER to space and see if that solves the issue.

JoshGeorge wrote:Writing into a fixed width file? Is the 'rectangle box' appended to fields which are defined as type char? Set the APT_PAD_CHARACTER to space and see if that solves the issue.

I am not writing to fixed width file. The column in corcern is varchar.