Combine Two Transforms in MySQL

giannzi

Hello, do you know what to type in Output DatasSets to have transform_data_1 as column 1 and transform_data_2 as column 2?

ColemenWilson

You would have to do a JOIN. https://www.w3schools.com/mysql/mysql_join.asp

If you share the contents of Transform 1 and 2 I can help you write it.

MarkSnodgrass

If you are struggling with this concept in MySQL, I would suggest you use Magic ETL to join the data. It is much easier to use and will run much faster. Here is a video on joining data in Magic ETL if you are unfamiliar with it.

https://youtu.be/EHm47saloVY