Select specific columns for join in Magic ETL



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


Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Accepted Answer

    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.