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?
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.
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.
