topic To join or not to join in QlikView

To join or not to join

Tue, 08 Nov 2011 15:27:52 GMT

Good morning. I have two tables in my load script...Sales History and Item Master. I want to create a third table that takes the Item Number from Sales History and concatenates it with the Item Description from Item Master ultimatley resulting in a "Item Number Name" field. Can someone please recommend the best way to do this? All of this needs to be done in my load script. I would like to do this using Resident loads. Thanks.

To join or not to join

jagan — Tue, 08 Nov 2011 15:58:24 GMT

Load the two tables Sales History and Item Master. And then join the two tables and use Resident to form the key.

Regards,

jagan.

To join or not to join

Tue, 08 Nov 2011 16:44:52 GMT

Let's say I do the following:

Table1:

Load

ItemNumber

Resident SalesHistory;

LEFT JOIN (Table1)

Load:

ItemNumber,

ItemDescription

Resident ItemMaster;

Will this get the trick done? If so where do I then add my new concatenated field? Field would be ItemNumber & ' - ' & ItemDescription