Loading data from different tables

Wed, 05 Sep 2012 08:42:44 GMT

I am working on a project. Here I have three tables with some fields common to each table.

I am attaching a sheet which will give u an idea on the structure of these tables.

What I need to do is:

Step1. Join table 1 & table 2 with Ano as the common field. Name this table as Table X

Step2. Add a calculated field in TableX which is a concatenation of : customer, cartidge, city, state. Name the field as KEY

Step3. Add a calculated field in Table3 which is a concatenation of CUSTOMER_NAME, Product Number,Ship City, ShipState. Name the field as KEY

Step4. Join Table X and Table 3 with KEY as common field. The final table structure (FInal Output) is shown in attached sheet.

Please help.

Abhishek

topic Loading data from different tables in QlikView