Pivot Stage - Column Derivation Limitation

[CGI_SUREN]

Hi All,

We are running into an issue where the Pivot is not sending the output properly when the derivation has more columns.
Pivot stage transposes records upto 7 columns properly and after that it ignores rest of the data.

We have around 19 columns that need to be transposed into records.
Pivot works fine for 7 columns and ignroes rest of the columns.

Any one seen this issue before?
Thanks in Advance.

[chulett]

I've recently pivoted 16 columns, there really shouldn't be a limit like that. Perhaps there is a data issue in the 8th column? You should probably involve your official support provider, see if perhaps that is a known issue with that stage.