Although the key is found in both data sources, when joining on Quicksight some data samples are not showing correctly.
Hi @ksari
Thanks for joining QuickSight Community and posting the question.
Could you please share screenshot with data samples where you are noticing issues. And also share additional details on the usecase.
Hello,
I can not share screenshots. It has confidential data.
The first datasource (redshift) has a field with a link and using sql i am taking a substring of this link.
The second datasource is a mysql db. It has a field which is the ticket ID.
When i join the two datasources on the ticket ID. The resulting dataset does not show the correct join of these two tables
Table 1
Field 1. field 2
11…………21
12………… 22
13………… 23
Table 2
Field 1. field 3
11………… 31
12………… 32
13………… 33
Table 1 righ join table 2 on field 1
If i join on field 1 the result is as follows;
Field 2. field 1. Field 3
21………… 11 ………… 31
22 ………… 12 ………… 32
… ………… 13 ………… 33
Although 13 is found in both the join is misbehaving.
Hey @ksari !
Are you still running into this problem?
If so, I would check your substring code to make sure it’s not doing anything that might cause the join to fail on those particular rows such as; Omitting leading 0’s in the case of converting to integer in case of the ticket ID being a number or that what you are joining with the same data types.
Hi @ksari,
Since we have not received a response from you on this question, we are going to archive this question. If you still need this question answered, please create a new question topic.
Many Thanks,
Andrew