Select specific columns for join in Magic ETL

user084060

Hi,

 

I am using Magic ETL for the first time and I am using two datasets and a left join to combine the two. I only want to left join one column from the 2nd table, but I cannot find where I can select for that in Magic ETL

jaeW_at_Onyx

hello @user084060 , 

screenshots help!

 

If i understand you correctly, you'll need 2x tiles.  the JOIN tile will allow you to ... join the dataset.  then use the SELECT tile to select the columns you want to keep.

jaeW_at_Onyx

hello @user084060 , 

screenshots help!

 

If i understand you correctly, you'll need 2x tiles.  the JOIN tile will allow you to ... join the dataset.  then use the SELECT tile to select the columns you want to keep.