Hi All,
I am currently working on an analysis in Amazon QuickSight and need assistance with displaying data from two related tables.
Here is the setup of the two tables I am using:
- Table 1 (
car_main
): Contains the fieldscar_id
andcar_name
. - Table 2 (
car_owner
): Contains the fieldscar_id
andowner_name
.
In my analysis, I am primarily working with the car_main
table, but I would like to display a field in the data table that shows the owners (from the car_owner
table) for each car as a comma-separated list.
We are aware that this could be achieved using SQL, specifically by using a STRING_AGG
or a similar function. However, we are trying to separate the datasets from any SQL manipulation and would prefer a solution that can be implemented directly via the QuickSight console — either in the analysis or dataset preparation phase.
Example Scenario:
If car_id = 1
corresponds to car_name = "Toyota"
, and the car_owner
table contains two records for this car (owner_name = "John"
and owner_name = "Jane"
), I want to display the result as:
Could you please advise on how this can be achieved using only the QuickSight console without resorting to SQL?
Thank you for your support!
Regards,
Rami