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.
Pivot Stage - Column Derivation Limitation
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers