Hi,
On one hand, I have a MySQL database where I do have a list of "issue" each with an "Iss Id".
On the other hand, I have a connection to Jira in which I get a different list of "JIRA Issues" and those all have a "Support case id" label field, which contains 1 or more "Iss Id".
How can I join the 2 databases together?
Thank you in advance.
Regards.
Julien
May 15, 2018 5:58 PM
Hello Julien,
For the data tables to be joined the joing clause will need to be fulfilled. Tableau Desktop currently is looking for a matching values only. If there are not matching values in the column or the columns are different data types the join will fail similarly too what is ocurring above. Can you verify that the data types of the two columns are similar.
Cheers,
Byrne, Patrick
Hello Patrick,
Indeed one of the columns is a character chain and the other one is a number. So I need to get a way to get those 2 as the same data types. I guess that this needs to be done on DB itself.
Regards.
Julien
May 16, 2018 10:54 AM
Hello Julien,
The data tables could possibly be joined on calculated field that creates a new column from one of the existing. More information on joining on calculated field can be found below.
+ https://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#whatsnew_desktop.html#join_oncalcs
Though if you can just normalize this data type. It could make future analysis easier.
Hope this helps!
Cheers,
Byrne, Patrick
We have done a view to change the data type and now all is working fine. Thank you very much.
May 29, 2018 2:32 PM
Happy to have been of assitance!