Joining two datasources (redshift - mysql) is misbehaving

Question & Answer
, ,
1

Although the key is found in both data sources, when joining on Quicksight some data samples are not showing correctly.

2

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.

3

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.