Hi there, I am watching your video on Dataflows and I would like to know more about the process.
I see that you have input, transformaiton and output.
I am confused because Transformaiton and Output are esentually the same. I could write an SQL statement that joins two tables together and gives an output. I am a little confused as to where I would put the join statement.
Would I just put the join statement in the transformation and then in the output just type
Select * from table; ?