How2 Extract Values from Two Related Tables that don't have a match

[thomdeluca]

PowerPivot newbie question.

What steps can I take to build/obtain query results that show values from Table "A" that don't have a match for values in Table "B".

Assume both tables share a common field, "Product ID".

Table "A" contains data from one source, Table "B" contains text fields that I wish to append to Table "A" values.

Table "A" updates with new items on occasion.

Purpose of query is to return list of items from Table "A" that don't currently have a corresponding "Product ID" in Table "B"; want query results to deliver a table of all those items from Table "A" so that I can then append them to Table "B"

Many Thanks!
- Tom

 

[Kazlik]

One option is to create a relationship on Product ID and then add a calculated column like this.Make your table and slice it based on this calculated column to get your list of items from Table "A" that don't currently have a corresponding "Product ID" in Table "B";

=IF( RELATED(Sheet2[Product ID]) <> Sheet1[Product ID], "Add","Do not add")

 

[scottsen]

I like kazlik's solution. I will add though... this problem feels better suited to Power Query.