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.

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!