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.

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.