Select specific columns for join in Magic ETL

Reply
Highlighted
Yellow Belt

Select specific columns for join in Magic ETL

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

Tags (3)

Accepted Solutions
Highlighted
Black Belt

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.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Highlighted
Black Belt

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.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.