Is it possible to concatenate two datasets in AWS QuickSight?
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
Can you clarify if you are trying to join theses on Analysis o datasource section?
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.
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
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.
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.
Joining Datasets with != Conditions in Quicksightasked 7 months ago
Access Denied error when creating a QuickSight dataset using botoasked 3 months ago
How can you merge several IoT datasetsasked 3 years ago
List of AWS Spice datasets and it's sizeasked 3 months ago
Do we have to Spice duplicate data?Accepted Answerasked 2 months ago
Error bringing in additional datasets/tables to Amazon Quicksight Datasetasked 4 months ago
Is it possible to concatenate two datasets in AWS QuickSight?asked 4 months ago
Copying a Cross-Source DataSet in QuickSight using the JS SDKasked 12 days ago
Delete Images in Custom Labels Datasetsasked 2 years ago
Quicksight not able to ingest dataset bigger than 1GB at a timeasked 5 months ago