Data Model Issue

[ankurakash]

Hi,

I have created a data model for which I sought your opinion and solution. Snapshot is posted below.

I have to add additional two tables to the data model. The issue is: if I add these tables it has common fields and will create synthetic key.

Sharing the structure of two tables:

1) Web_Auth

2) Web_Staging

Structure of both tables mentioned below:

1. //Web_Auth:
   //LOAD TAX_PAYER_NO,
   //     USERID,
   //     CREATE_DATE  (Required field - Date filter required.)
   //FROM
   //[..\Data\QVD\Web_Auth.QVD]
   //(qvd);
   //
   

  2. //Web_Staging:          
//LOAD // E_FILE_NO,
//    TAX_TYPE_NO,   (required field)
//   TAX_PAYER_NO,  (required field)
//   CREATED_DATE,  (required field)

//[..\Data\QVD\Web_Staging.QVD]
//(qvd);
//

I think linking would be a solution but I am not getting close to the solution. It would be of great help if QlikView Experts can guide me through steps that I need to take to include the above tables in the data model.

Regards,

Ankur Akash

[Siva_Sankar]

Ankur,

I didnt see a synthetic key in your data model. Can you share your qlikview file once after loading all data?

[PrashantSangle]

Hi,

Just Key create Key Field by combining those field which gives you unique data.

and Rename other field which is required but created Synthetic Keys.

Regards

[ankurakash]

Attached is the data model

[Siva_Sankar]

Ankur,

Follow the steps in the attached document. I dont have the clarity of data from the screenshot.