Joining two datasets to add an extra field to a table

Question & Answer
,
1

Hi,

I have a dataset that contains “tradeId” field and some other fields.
I want to be able to add an “annotation” field to some of the trades, but the annotation field would come from a different dataset where i have the “tradeID” and “annotation” field (only for the trades that have annotations requested). I would like to sort of join this two datasets so i can then display the annotations and all the other field in one single table. I understand there is a way to join datasets in QuickSight but as I’m not too familiar with the process I would like to ask if anyone could give me some advice on how to do this or if is even possible to achieve this in QuickSight.

Thank you in advance,

Domenico

2

Hello @Dom,

Here is a blog post explaining how to perform joins between datasets

If you have any doubts, feel free to ask for any clarification here.

Hope this helps!

1 Like