Merge Transform is used to merge rows from multiple tables. The only condition for the Merge transform to work is that the structure of the source tables should be same.
This is exact opposite of what we do in Case Transform. But we cannot provide any condition in Merge.
Login to your data services. Create a new Project, call it as ‘Merge_Transform’.
Create Job, workflow and dataflow.
We have created some tables in the Case transform, we will use the same tables to merge the data.
Import the target template tables from your case transform: Continue reading →