Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading data from different tables

Hi

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

Community Browser