8 Replies Latest reply on Mar 2, 2018 11:23 AM by arvindgarg

Type Mismatch on Join

Brian Fornelius Mar 2, 2018 9:07 AM

Hi all.

I am trying to join a Redshift Custom SQL to a MySQL Database and am running into a type mismatch.

On connecting the field in MySQL shows it as a 'Number (decimal) the Custom SQL displays it as Number (whole). Even if I try to change the field type is still remains mismatched and the only think that looks different is the default.

MySQL

RedShift Custom SQL

How do I change one of the other so that they will match. I read that you can create a calculation or something but I'm not sure how to even go about doing that.

Thanks,

--B

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.
Like Show 0 Likes(0)

Actions
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?
Like Show 0 Likes(0)

Actions
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.

CAST and CONVERT Functions - Amazon Redshift
Like Show 0 Likes(0)

Actions
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...
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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?
Like Show 0 Likes(0)

Actions
8. Re: Type Mismatch on Join

arvindgarg Mar 2, 2018 11:23 AM (in response to Brian Fornelius)

I believe, It should be fine.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Type Mismatch on Join

1. Re: Type Mismatch on Join

2. Re: Type Mismatch on Join

3. Re: Type Mismatch on Join

4. Re: Type Mismatch on Join

5. Re: Type Mismatch on Join

6. Re: Type Mismatch on Join

7. Re: Type Mismatch on Join

8. Re: Type Mismatch on Join

Actions

More Like This