Hi
I am passing 10 column as the input to sort stage and taking the same number of columns as the output.
But in the run time i am getting the error
"Input column does not promote to output column"
Can any one help me in this?
Thanks in advance
Ram
Input column does not promote to output column
Moderators: chulett, rschirm, roy
Re: Input column does not promote to output column
SURA wrote:Hi
I am passing 10 column as the input to sort stage and taking the same number of columns as the output.
But in the run time i am getting the error
"Input column does not promote to output column"
Can any one help me in this?
Thanks in advance
Ram
There is no change. Both input and output are same. I foudn some workaround. Post it once it is confirmed.
Thanks
Ram
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am having a similar problem. Getting the error 'Input column does not promote to output column' and my input and output columns are the exact same. My inputs were saved, then loaded into my outputs, so there is no change in position, SQL type, etc.
Edit: I took the column in the sort input/output link that was causing this error and changed it to a 'Key' column. This fixed the error.
I had 203 columns, and 5 columns that defined a distinct record. The first three columns were keys, then the column that was causing this error (not a key), then two more keys after that. I am not sure if it is part of the reason the fix worked, but making the non-key column which was between the key columns at the top of the link's list of columns into a Key fixed the issue.
Edit: I took the column in the sort input/output link that was causing this error and changed it to a 'Key' column. This fixed the error.
I had 203 columns, and 5 columns that defined a distinct record. The first three columns were keys, then the column that was causing this error (not a key), then two more keys after that. I am not sure if it is part of the reason the fix worked, but making the non-key column which was between the key columns at the top of the link's list of columns into a Key fixed the issue.