Kloudio provides an option to add join conditions for multiple tables. Please follow the below steps to join two tables
Step 1: Create a Report by following steps:
Navigate to the Reports page and click on
Select the connection you created earlier.
Choose the schema/database name where your data resides.
Pick your table from the results
Select all or individual columns in the report by clicking on the column name.
Step 2: Select the other table to join:
Now select the matching columns for which you need to create the Join conditions
Select the required columns for the table you need to join
Now join popup will be visible. Select any one of the following four join types:
Inner Join
Outer Join
Left Join
Right Join
Step 3: Select the columns from the two tables and the required Join condition and once join condition is selected, click OK then all the respective joined tables will be visible
Step 4: Now you can see the preview after joining the tables, Save the Join tables with required name.
Congratulations! You have successfully joined multiple tables in Reports with Kloudio.