How do we join two tables and load data into a target in Diyotta?
We can join two or more tables in Diyotta through Joiner transformation. We should create a dataflow under generic or any native databases for which we are licensed and Drag the source tables into the data flow. Add the joiner transform which is available in the Transforms tab.
Mention the condition in the properties tab of the joiner transform. Joiner type has a drop down, in which we can select the type of join we would like to perform.
Add the required attributes in the Attributes tab as below
Create target from the joiner with the attributes added and execute the dataflow. Based on the given condition tables will be joined and loaded into target.