Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ankurakash
Not applicable

Data Model Issue

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

4 Replies
Siva_Sankar
Not applicable

Re: Data Model Issue

Ankur,

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

PrashantSangle
Not applicable

Re: Data Model Issue

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

Great dreamer's dreams never fulfilled, they are always transcended.
ankurakash
Not applicable

Re: Data Model Issue

Attached is the data model

Siva_Sankar
Not applicable

Re: Re: Data Model Issue

Ankur,

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