Im sorting data using Sort Stage. In the Sort stage Im using Create Key Change Column option. The keyChange datatype by default is TinyInt.
I need to use it as a calculation for a Integer and Decimal(9,2) type datatype target columns.
How do I go about the type conversion?
keyChange Column type conversion
Moderators: chulett, rschirm, roy
I would expect the tinyInt to be useable in a transform computation - but if not then you would have to do a cast either in the transform itself or resort to the use of a MODIFY stage to change the datatype explicitly.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>