-
1. Re: Connecting 2 datasource, 1 being Jira and the key being in a list....
patrick.byrne.0May 15, 2018 5:58 PM (in response to Julien Fritsch)
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
-
2. Re: Connecting 2 datasource, 1 being Jira and the key being in a list....
Julien Fritsch May 16, 2018 5:46 AM (in response to patrick.byrne.0)1 of 1 people found this helpfulHello 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
-
3. Re: Connecting 2 datasource, 1 being Jira and the key being in a list....
patrick.byrne.0May 16, 2018 10:54 AM (in response to Julien Fritsch)
1 of 1 people found this helpfulHello 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
-
4. Re: Connecting 2 datasource, 1 being Jira and the key being in a list....
Julien Fritsch May 18, 2018 8:23 AM (in response to patrick.byrne.0)We have done a view to change the data type and now all is working fine. Thank you very much.
-
5. Re: Connecting 2 datasource, 1 being Jira and the key being in a list....
patrick.byrne.0May 29, 2018 2:32 PM (in response to Julien Fritsch)
Happy to have been of assitance!