Error: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You cannot post a blank message. Please enter your message and try again. Please enter a title. You cannot post a blank message. Please enter your message and try again. Hi, I have a doubt regarding Decode function.
How this works. This content has been marked as final. Show 10 replies. Please enter your message and try again. Thanks, Lavan. This content has been marked as final. Show 10 replies. Can we solve this by using IF function? Hi Lavan, Try this once Take Expression Transformation. The value you want to return if the search does not find a matching value.
Return Value. Default value if the search does not find a matching value. NULL if you omit the default argument and the search does not find a matching value. Even if multiple conditions are met, Data Integration. If the data contains multibyte characters and the DECODE expression compares string data, the return value depends on the code page of the Secure Agent that runs the task.
When you use DECODE, the datatype of the return value is always the same as the datatype of the result with the greatest precision. For example, you have the following expression:. The return values in this expression are 5, 1. The first result is an Integer, and the other results are Decimal. The Decimal datatype has greater precision than Integer. This expression always writes the result as a Decimal.
0コメント