Joining only where Unique ID matches

Lancers88

I have 2 data sets. Data Set A and Data Set B.

Data Set A.

Has 6k rows of data and about 50 columns, and it has a unique column ID That can be matched a Unique ID within in Set B.

Data Set B.

Has 20k rows of data and about 30 columns, this also has a unique column ID.

The Unique Column ID will match up on about 1000 different rows of data. I want to create a data set of just those 1000 rows. Is it possible to have the two data sets only join where those columns match?

I am fine if you point me to past ?'s and or articles, I am just stumped and have not been able to figure it out. FYI I was able to figure out what I wanted in Excel by pasting both data sets on to one table and then using the indexing function ( see below) and then filtering my results just hoping I can make this work in Domo too. Here is the function I used in Excel.

=INDEX($E$2:$E$6000, MATCH($A2, $F$2:$F$1000, 0))

DavidChurchman

What you're describing is an "inner join". You can do it in Magic ETL: https://domohelp.domo.com/hc/en-us/articles/360044876194-Magic-ETL-Tiles-Combine-Data or DataFusion: https://domohelp.domo.com/hc/en-us/articles/360043428293-Combining-DataSets-Using-DataFusion

DataFusion is simpler. All it does is join the data. Magic ETL gives you many more options for transforming your data in addition to the join.

Lancers88

Thanks David I will give this a shot. Appreciate the quick response and help. You are great.