topic Re: Combining two tables into one in QlikView

Combining two tables into one

jmonroe918 — Fri, 04 Apr 2014 19:44:35 GMT

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

Re: Combining two tables into one

Anonymous — Fri, 04 Apr 2014 20:02:38 GMT

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');

Re: Combining two tables into one

its_anandrjs — Fri, 04 Apr 2014 20:27:25 GMT

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.

Re: Combining two tables into one

jmonroe918 — Fri, 04 Apr 2014 20:50:52 GMT

Michael:

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

Re: Combining two tables into one

Anonymous — Sat, 05 Apr 2014 13:14:57 GMT

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

New_Prod:

RIGHT KEEP (Complaints)

LOAD

...

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