Join data easily
A join creates a data source with columns coming from two (or more) tables. How can you create them? Are there risks? You'll learn everything in this section.
The join principle
So far, we've only used one table. A join is automatically created when you drag and drop another table next to an existing one in the data source workplace. There is always a left-hand table and a right-hand table. In the following screenshot, you can see a join between Orders (the left-hand table), and People (the right-hand table):
The result of a join is a data source that contains the columns from the different joined tables. As highlighted in the screenshot, ...