-
1. Re: Type Mismatch on Join
arvindgarg Mar 2, 2018 9:25 AM (in response to Brian Fornelius)You can use cast function, round function in sql. this way you can convert one whole to decimal OR vice versa. Then you can try joining.
-
2. Re: Type Mismatch on Join
Brian Fornelius Mar 2, 2018 9:30 AM (in response to arvindgarg)that's the problem... I'm not even sure how to do that.
If id.1 is Number (Decimal) and Id.2 is in the Custom SQL as Number (whole) how do I cast function to change one?
-
3. Re: Type Mismatch on Join
arvindgarg Mar 2, 2018 9:39 AM (in response to Brian Fornelius)see below URL. it talks about convert and cast functions. you can use this in custom SQL.
-
4. Re: Type Mismatch on Join
Brian Fornelius Mar 2, 2018 9:44 AM (in response to arvindgarg)thanks... I will give this a try...
-
5. Re: Type Mismatch on Join
Brian Fornelius Mar 2, 2018 10:05 AM (in response to Brian Fornelius)so... even if I do a 'cast(number_id AS DECIMAL)' in the Redshift Custom SQL it still shows as a type mismatch and showing as a number (whole) in the error message.
-
6. Re: Type Mismatch on Join
arvindgarg Mar 2, 2018 10:15 AM (in response to Brian Fornelius)Sorry, I would need to see workbook and details about the error.
-
7. Re: Type Mismatch on Join
Brian Fornelius Mar 2, 2018 11:19 AM (in response to arvindgarg)so I did a join calculation and did INT(number_id) and the join connected. Is that a workable option? I'm loading the data now so hopefully that did the trick?
-
8. Re: Type Mismatch on Join
arvindgarg Mar 2, 2018 11:23 AM (in response to Brian Fornelius)I believe, It should be fine.