This page provides step-by-step instructions for combining existing datasets without SQL.

1. Select the dataset with which you want to join another dataset. Click Use in Dataset > Add Data > Dataset. Select the other dataset that you want to combine with the current dataset.
   
   
2. Select the desired join configurations. Then, click Apply.
   
   
3. Name the view accordingly. Then, click Save & publish > Cancel (to exit the query editor).
   
   

Now the dataset can be used to replace the dataset in the desired dashboard (refer to the GIF below) or a new analysis can be created based your desired use case.

The newly created dataset will be available under your 'Datasets' in the homepage of the Dashboard Authoring console.

1. To create a new analysis with this new dataset created, click on the kebab menu on the right of the dataset > Use in Analysis.
2. To replace an existing dataset with the newly created dataset in a certain analysis, open the analysis in which you want to use this dataset > Click on the 'pencil icon' next to the Dataset being used > click on the 'kebab' menu on the right of the dataset > 'Replace'.
3. Now you will see a list of dataset options with which you can replace the existing dataset.
4. Select the dataset with which you want to replace > Click on 'Replace'.

Note: The column names in the new dataset needs to match the column names of the existing dataset (for all the columns available in the existing dataset). If the column names exactly match, the transition will be smooth. If not, it will ask you for the columns which needs to be newly mapped or the columns you want to ignore.