Combining two tables into one

[jmonroe918]

I have two tables in my dashboard that I want to join. One table is a list of new product numbers (New_Prod) and the other is a table of complaints (Complaints).

Complaints is created earlier in the load script and used on another sheet. I would like to join these two tables by the Part Number field, so that I get a table that lists only the complaints that match a part number in New_Prod. And I want to attach a couple of the fields to this new table (Business Unit and Product Group).

I've attached the files.

Thanks.

Jeff

[Anonymous]

As I understand, you want to have only one table - Complaints.  It should have Part Number only which exists in current New_Prod, and it should have Business Unit and Product Brand fields.
If I got it right, you need replace your New_Prod with this:

RIGHT JOIN (Compliants)
LOAD
[Item No] as [Part Number],
[Business Unit],
[Product Brand]
FROM

(ooxml, embedded labels, table is MST_Items_Released)
WHERE([Item Type] = 'MFG Finished Good' Or [Item Type] = 'PUR Finished Good');

[its_anandrjs]

You have to load your table like

Complaints:

Load Fields from Location;

Right Join(Complaints)

New_Prod:

LOAD

  [Item No] as [Part Number],

     [Item Description],

     [Effectivity Date],

     Year,

     Month,

     [Item Type],

     [Business Unit],

     [Product Brand]

FROM

(ooxml, embedded labels, table is MST_Items_Released)

WHERE([Item Type] = 'MFG Finished Good' Or [Item Type] = 'PUR Finished Good');

From based on New_Prod table all [Part Number] records are added in to new table.

[jmonroe918]

Michael:

I would like to leave the original complaints table untouched. Can I give this new table its own name?

[Anonymous]

I understood the "join" requirement literally.  If now I got right what you need, it is simple:

New_Prod:

RIGHT KEEP (Complaints)

LOAD

<and the rest is the same as in my previous reply>

...

You get the Complaints table as it was but containing only the records where Part Number matches values in the New_Prod.  New_Prod itself is a separate table here.

Regards,

Michael