Is it possible to concatenate two datasets in AWS QuickSight?

0

I have several datasets uploaded from xlsx files that have matching column names. Is it somehow possible to concatenate/unify these datasets into one?

I tried to do this in Datasets > Edit Dataset > Add data, but there the only option for merging several datasets together was a join operation.

Example: if I have a dataset with M -rows and N-columns and another one with M2 Rows and N columns, I would like that the final dataset after concatenation would be M + M2 rows and N columns

gefragt vor 2 Jahren4486 Aufrufe
3 Antworten
2

Your best bet might be to create Athena tables for each dataset, use Athena to create a 'view' that is a union all, then import that view into QuickSight.

AWS
beantwortet vor 2 Jahren
0

Can you clarify if you are trying to join theses on Analysis o datasource section?

Elvin
beantwortet vor 2 Jahren
  • Well I do not really mind if the concatenation is done on analysis or dataset level. Example: if I have a dataset with M -rows and N-columns and another one with M2 Rows and N columns, I would like that the final dataset after concatenation would be M + M2 rows and N columns

  • please post this type of answers as comments to the question.

0

you can use calculated fields for that - it can be done on analysis or dataset level https://docs.aws.amazon.com/quicksight/latest/user/adding-a-calculated-field-analysis.html

AWS
Alex_T
beantwortet vor 2 Jahren
  • How does this help me? I do not want to add any new fields to the dataset, but I want to basically row-join two datasets. Example: if I have one dataset with M rows and N columns and another with M2 rows and N columns, I would like the final dataset after concatenation to have M + M2 rows and N columns.

  • the user is asking for the ability to make a Union between 2 datasets, not to add a concatenate function as calculated field.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen